APPS.PO_REQ_DOCUMENT_UPDATE_PVT dependencies on PO_SESSION_GT

Line 58: l_key po_session_gt.key%type;

54: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
55: l_dist_total_qty PO_TBL_NUMBER;
56: l_last_dist_index PO_TBL_NUMBER;
57: l_line_count NUMBER := p_lines.req_line_id.count;
58: l_key po_session_gt.key%type;
59:
60: BEGIN
61:
62: IF g_fnd_debug = 'Y' THEN

Line 77: -- PO_SESSION_GT column mapping

73: l_sequence(i) := i;
74: END LOOP;
75:
76: ----------------------------------------------------------------
77: -- PO_SESSION_GT column mapping
78: --
79: -- Removed num3, num4, num5 and code for
80: -- tax proration Tax will now be recalculated not prorated
81: --

Line 88: select po_session_gt_s.nextval into l_key from dual;

84: -- num9 Req Line Sequence
85: -- num10 Req Distribution ID
86: ----------------------------------------------------------------
87:
88: select po_session_gt_s.nextval into l_key from dual;
89:
90: -- Derive LineTotal and DistributionQuantity
91: FORALL i IN 1..l_line_count
92: INSERT

Line 93: INTO po_session_gt

89:
90: -- Derive LineTotal and DistributionQuantity
91: FORALL i IN 1..l_line_count
92: INSERT
93: INTO po_session_gt
94: (key,
95: num9, --Req Line Sequence
96: num10, --Req Distribution ID
97: num1) --Req Distribution Quantity

Line 117: from po_session_gt

113: max(num10)
114: BULK COLLECT INTO
115: l_dist_total_qty,
116: l_last_dist_index
117: from po_session_gt
118: where key = l_key
119: group by num9
120: order by num9; --Group and Order by Req Line Sequence stored in num9
121:

Line 126: update po_session_gt

122: -- Add any proration remainder to the last distribution in the line
123: -- num1 Req Distribution Quantity
124: -- num10 Req Distribution ID
125: FORALL i IN 1..l_line_count
126: update po_session_gt
127: set num1 = num1 + (p_lines.quantity(i) - l_dist_total_qty(i))
128: where key = l_key and num10 = l_last_dist_index(i);
129:
130: -- Derive Line Total

Line 132: update po_session_gt

128: where key = l_key and num10 = l_last_dist_index(i);
129:
130: -- Derive Line Total
131: FORALL i IN 1..l_line_count
132: update po_session_gt
133: set
134: num2 --Req New Line Total
135: = (select
136: --New Line Total

Line 160: FROM po_session_gt

156: BULK COLLECT INTO
157: p_distributions.distribution_id,
158: p_distributions.quantity,
159: p_distributions.total
160: FROM po_session_gt
161: where key = l_key;
162:
163: delete from po_session_gt where key = l_key;
164:

Line 163: delete from po_session_gt where key = l_key;

159: p_distributions.total
160: FROM po_session_gt
161: where key = l_key;
162:
163: delete from po_session_gt where key = l_key;
164:
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: EXCEPTION