DBA Data[Home] [Help]

APPS.PO_DATATEMPLATE_PKG dependencies on PO_ACCEPTANCES

Line 83: SELECT 'S' INTO bil_indicator FROM PO_ACCEPTANCES WHERE po_header_id = p_header_id AND draft_id = p_draft_id

79: bil_indicator := 'N';
80: IF (p_auth_status <> 'INCOMPLETE' AND p_auth_status <> 'IN PROCESS') THEN
81:
82: Begin
83: SELECT 'S' INTO bil_indicator FROM PO_ACCEPTANCES WHERE po_header_id = p_header_id AND draft_id = p_draft_id
84: AND accepting_party = 'S' AND accepted_flag = 'Y' AND signature_flag = 'Y';
85:
86: Exception
87: when no_data_found then

Line 89: SELECT 'B' INTO bil_indicator FROM PO_ACCEPTANCES WHERE po_header_id = p_header_id AND draft_id = p_draft_id

85:
86: Exception
87: when no_data_found then
88: BEGIN
89: SELECT 'B' INTO bil_indicator FROM PO_ACCEPTANCES WHERE po_header_id = p_header_id AND draft_id = p_draft_id
90: AND accepting_party = 'B' AND accepted_flag = 'Y' AND signature_flag = 'Y';
91:
92: Exception
93: when no_data_found then