[Home] [Help]
16: -- None.
17: --Locks:
18: -- None.
19: --Procedure:
20: -- This procedure returns information about 'pay when paid' status for a standard PO.
21: -- In case the type of the PO is other than 'Standard', there is no need to
22: -- apply any hold. This proc simply returns a pay_when_paid -> 'N' to the caller.
23: --Parameters:
24: --IN:
17: --Locks:
18: -- None.
19: --Procedure:
20: -- This procedure returns information about 'pay when paid' status for a standard PO.
21: -- In case the type of the PO is other than 'Standard', there is no need to
22: -- apply any hold. This proc simply returns a pay_when_paid -> 'N' to the caller.
23: --Parameters:
24: --IN:
25: --p_api_version
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');
91: END IF;
92:
93: IF l_type_lookup_code <> 'STANDARD'
94: THEN
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: x_pay_when_paid := 'N';
97: END IF;
112: --Locks:
113: -- None.
114: --Procedure:
115: -- This procedure returns a 'Y' or 'N' based on the contract deliverables' status.
116: -- In case the type of the PO in picture is other than 'Standard', there is no need to
117: -- apply any hold. This proc simply returns a hold_required -> 'N' to the caller.
118: -- In this case, we do not call OKC api which provides paymenthold information.
119:
120: --Parameters:
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: d_progress := '002';
181:
182: /* Bug 8204164 - The below query was initially checking for the document type = 'STANDARD'.
183: Changed that to query all type_lookup_codes as this proc is called \
184: from AP for all types of POs.
185: Added fnd debug messages as well */
186:
194: WHERE po_header_id = p_po_header_id;
195:
196:
197:
198: IF l_type_lookup_code <> 'STANDARD'
199: THEN
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201: X_HOLD_REQUIRED := 'N';
202: END IF;