eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_CORE_S dependencies on PO_HEADERS_DRAFT_ALL

Line 8252: header_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;

8248: -------------------------------------------------------------------------------
8249: FUNCTION get_last_update_date_for_mod(p_doc_id IN NUMBER) RETURN DATE
8250: IS
8251: draft_last_update_date PO_DRAFTS.last_update_date%type;
8252: header_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8253: line_last_update_date PO_LINES_DRAFT_ALL.last_update_date%type;
8254: line_loc_last_update_date PO_LINE_LOCATIONS_DRAFT_ALL.last_update_date%type;
8255: dist_last_update_date PO_DISTRIBUTIONS_DRAFT_ALL.last_update_date%type;
8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;

Line 8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;

8252: header_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8253: line_last_update_date PO_LINES_DRAFT_ALL.last_update_date%type;
8254: line_loc_last_update_date PO_LINE_LOCATIONS_DRAFT_ALL.last_update_date%type;
8255: dist_last_update_date PO_DISTRIBUTIONS_DRAFT_ALL.last_update_date%type;
8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8257: address_last_update_date po_headers_all_ext_b.last_update_date%type;
8258: org_assign_last_update_date po_ga_org_assign_draft.last_update_date%type;
8259: --Lowest date supported by database as we need to handle null dates
8260: min_date PO_HEADERS_DRAFT_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');

Line 8260: min_date PO_HEADERS_DRAFT_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');

8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8257: address_last_update_date po_headers_all_ext_b.last_update_date%type;
8258: org_assign_last_update_date po_ga_org_assign_draft.last_update_date%type;
8259: --Lowest date supported by database as we need to handle null dates
8260: min_date PO_HEADERS_DRAFT_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');
8261:
8262: l_module_name CONSTANT VARCHAR2(100) := 'GET_LAST_UPDATE_DATE_FOR_MOD';
8263: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(g_log_head, l_module_name);
8264: d_pos NUMBER := 0;

Line 8271: select nvl(max(last_update_date), min_date) into header_last_update_date from po_headers_draft_all where draft_id = p_doc_id;

8267: IF (PO_LOG.d_proc) THEN
8268: PO_LOG.proc_begin(d_module_base); PO_LOG.proc_begin(d_module_base, 'p_doc_id', p_doc_id);
8269: END IF;
8270: d_pos := 10;
8271: select nvl(max(last_update_date), min_date) into header_last_update_date from po_headers_draft_all where draft_id = p_doc_id;
8272: d_pos := 20;
8273: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_draft_all where draft_id = p_doc_id;
8274: d_pos := 30;
8275: select nvl(max(last_update_date), min_date) into line_loc_last_update_date from po_line_locations_draft_all where draft_id = p_doc_id;