DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_CORE_S

Line 1544: l_key := PO_CORE_S.get_session_gt_nextval;

1540:
1541: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
1542:
1543: -- assign a new key used in temporary table
1544: l_key := PO_CORE_S.get_session_gt_nextval;
1545:
1546: -- initialize table containing the row number(index)
1547: PO_PDOI_UTL.generate_ordered_num_list
1548: (

Line 2042: l_key := PO_CORE_S.get_session_gt_nextval;

2038:
2039: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2040:
2041: -- assign a new key used in temporary table
2042: l_key := PO_CORE_S.get_session_gt_nextval;
2043:
2044: -- initialize table containing the row number(index)
2045: PO_PDOI_UTL.generate_ordered_num_list
2046: (

Line 2277: l_key := PO_CORE_S.get_session_gt_nextval;

2273:
2274: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
2275:
2276: -- get key value to identify rows in po_session_gt table
2277: l_key := PO_CORE_S.get_session_gt_nextval;
2278:
2279: -- default line_type_id that will be used in other defaulting logic;
2280: -- l_index_tbl table is initialized as well
2281: FOR i IN 1..x_lines.rec_count

Line 2676: l_key := PO_CORE_S.get_session_gt_nextval;

2672:
2673: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2674:
2675: -- assign a new key used in temporary table
2676: l_key := PO_CORE_S.get_session_gt_nextval;
2677:
2678: -- initialize table containing the row number(index)
2679: PO_PDOI_UTL.generate_ordered_num_list
2680: (

Line 3241: l_key := PO_CORE_S.get_session_gt_nextval;

3237:
3238: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
3239:
3240: -- get key value for po_session_gt table
3241: l_key := PO_CORE_S.get_session_gt_nextval;
3242:
3243: -- call individual uniqueness check procedure for each unique criteria
3244: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
3245: d_position := 10;

Line 5756: l_key := PO_CORE_S.get_session_gt_nextval;

5752: PO_LOG.proc_begin(d_module);
5753: END IF;
5754:
5755: -- get new key value for po_session_gt table
5756: l_key := PO_CORE_S.get_session_gt_nextval;
5757:
5758: -- match lines whose line_num is not null
5759: -- first, try to find matching line in draft table
5760: FORALL i IN 1..x_lines.rec_count

Line 5904: l_key := PO_CORE_S.get_session_gt_nextval;

5900: PO_LOG.proc_begin(d_module);
5901: END IF;
5902:
5903: -- get key value for po_session_gt table
5904: l_key := PO_CORE_S.get_session_gt_nextval;
5905:
5906: -- First, get lines qualified. The qualified lines must satisfy the following conditions:
5907: -- 1. x_lines.line_num_tbl(i) IS NULL
5908: -- 2. x_lines.hd_actions(i) <> 'UPDATE'

Line 6012: l_data_key := PO_CORE_S.get_session_gt_nextval;

6008:
6009: d_position := 40;
6010:
6011: -- b. match within the same batch
6012: l_data_key := PO_CORE_S.get_session_gt_nextval;
6013: -- initialize table containing the row number(index)
6014: PO_PDOI_UTL.generate_ordered_num_list
6015: (
6016: p_size => x_lines.rec_count,

Line 6584: l_data_key := PO_CORE_S.get_session_gt_nextval;

6580:
6581: -- search within the batch
6582: -- find out all lines that cannot find a match
6583: -- and set their action to ADD
6584: l_data_key := PO_CORE_S.get_session_gt_nextval;
6585: FORALL i IN INDICES OF x_processing_row_tbl
6586: INSERT INTO po_session_gt
6587: (
6588: key,

Line 6874: l_data_key := PO_CORE_S.get_session_gt_nextval;

6870:
6871: -- search within the batch
6872: -- find out all lines that cannot find a match
6873: -- and set their action to ADD
6874: l_data_key := PO_CORE_S.get_session_gt_nextval;
6875: FORALL i IN INDICES OF x_processing_row_tbl
6876: INSERT INTO po_session_gt
6877: (
6878: key,

Line 7140: l_data_key := PO_CORE_S.get_session_gt_nextval;

7136:
7137: -- search within the batch
7138: -- find out all lines that cannot find a match
7139: -- and set their action to ADD
7140: l_data_key := PO_CORE_S.get_session_gt_nextval;
7141: FORALL i IN INDICES OF x_processing_row_tbl
7142: INSERT INTO po_session_gt
7143: (
7144: key,

Line 7401: l_data_key := PO_CORE_S.get_session_gt_nextval;

7397:
7398: -- search within the batch
7399: -- find out all lines that cannot find a match
7400: -- and set their action to ADD
7401: l_data_key := PO_CORE_S.get_session_gt_nextval;
7402: FORALL i IN INDICES OF x_processing_row_tbl
7403: INSERT INTO po_session_gt
7404: (
7405: key,

Line 7611: l_data_key := PO_CORE_S.get_session_gt_nextval;

7607:
7608: -- search within the batch
7609: -- find out all lines that cannot find a match
7610: -- and set their action to ADD
7611: l_data_key := PO_CORE_S.get_session_gt_nextval;
7612: FORALL i IN INDICES OF x_processing_row_tbl
7613: INSERT INTO po_session_gt
7614: (
7615: key,

Line 7843: l_key := PO_CORE_S.get_session_gt_nextval;

7839: PO_LOG.proc_begin(d_module);
7840: END IF;
7841:
7842: -- assign a new key used in temporary table
7843: l_key := PO_CORE_S.get_session_gt_nextval;
7844:
7845: -- initialize table containing the row number(index)
7846: PO_PDOI_UTL.generate_ordered_num_list
7847: (