DBA Data[Home] [Help]

APPS.GR_PROCESS_DOCUMENTS_INSERTS dependencies on GR_WORK_BUILD_DOCS

Line 736: -- This PL/SQL procedure is used to insert a row into GR_WORK_BUILD_DOCS.

732: -- PROCEDURE:
733: -- Insert_Work_Row
734: --
735: -- DESCRIPTION:
736: -- This PL/SQL procedure is used to insert a row into GR_WORK_BUILD_DOCS.
737: --
738: -- PARAMETERS:
739: -- p_session_id IN NUMBER - Session id for report
740: -- p_document_code IN VARCHAR2 - Document type being printed

Line 801: FROM gr_work_build_docs wbd

797: ** heading and subheading combination
798: */
799: CURSOR c_get_existing_phrase IS
800: SELECT wbd.print_flag
801: FROM gr_work_build_docs wbd
802: WHERE wbd.document_code = p_document_code
803: AND wbd.main_heading_code = p_main_heading_code
804: AND wbd.sub_heading_code = p_sub_heading_code
805: AND wbd.record_type = p_label_or_phrase_code

Line 829: INSERT INTO gr_work_build_docs

825: CLOSE c_get_existing_phrase;
826: END IF;
827:
828: IF l_update_ok = 'YS' THEN
829: INSERT INTO gr_work_build_docs
830: (session_id,
831: sequence_number,
832: document_code,
833: main_heading_code,

Line 848: gr_work_build_docs_s.nextval,

844: source_itemcode,
845: structure_display_order)
846: VALUES
847: (p_session_id,
848: gr_work_build_docs_s.nextval,
849: p_document_code,
850: p_main_heading_code,
851: p_main_display_order,
852: p_sub_heading_code,