DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_SESSION_GT_S

Line 5459: select PO_SESSION_GT_S.nextval into l_session_key from dual;

5455:
5456:
5457: p_po_line_num_disp_tbl.extend(l_end_index - l_start_index + 1);
5458: -- get the session key
5459: select PO_SESSION_GT_S.nextval into l_session_key from dual;
5460:
5461: -- get the action whether the line is being added(match case) or new line
5462: l_action_tbl := PO_AUTOCREATE_GROUPING_PVT.get_line_action_tbl(p_po_line_num_tbl,
5463: p_add_to_po_header_id,

Line 5595: for rec in (select slins.num1, slins.char5 from po_session_gt clins, po_session_gt slins

5591: loop
5592: l_next_info_slin_num := po_line_num.char4;
5593: l_next_priced_slin_num := po_line_num.char6;
5594: -- loop through the list of slins pointing to clins with the same line number
5595: for rec in (select slins.num1, slins.char5 from po_session_gt clins, po_session_gt slins
5596: where clins.key = l_session_key
5597: and slins.key = l_session_key
5598: AND clins.num3 = po_line_num.num3 -- po line number
5599: and slins.num2 = clins.num1 -- slins.group line id = clins.line id