DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on EGO_EXTFWK_S

Line 3937: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL

3933: l_old_line_loc_ext_id_tbl PO_TBL_NUMBER;
3934: l_new_line_loc_ext_id_tbl PO_TBL_NUMBER;
3935:
3936: CURSOR po_headers_ext_cursor IS
3937: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
3938: FROM PO_HEADERS_ALL_EXT_B_ARCHIVE
3939: WHERE po_header_id = p_document_id
3940: AND draft_id = -1
3941: AND revision_num = p_revision_num;

Line 3944: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL

3940: AND draft_id = -1
3941: AND revision_num = p_revision_num;
3942:
3943: CURSOR po_lines_ext_cursor IS
3944: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,
3946: PO_LINES_ALL POL
3947: WHERE POL.po_header_id = p_document_id
3948: AND POL.po_line_id = POLE.po_line_id

Line 3953: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL

3949: AND POLE.draft_id = -1
3950: AND POLE.revision_num = p_revision_num;
3951:
3952: CURSOR po_line_loc_ext_cursor IS
3953: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3954: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POLE,
3955: PO_LINE_LOCATIONS_ALL POL
3956: WHERE POL.po_header_id = p_document_id
3957: AND POL.line_location_id = POLE.line_location_id