APPS.PO_VAL_HEADERS dependencies on STANDARD

Line 29: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

25: c_MANUAL CONSTANT VARCHAR2(30) := 'MANUAL';
26: c_NUMERIC CONSTANT VARCHAR2(30) := 'NUMERIC';
27: c_PLANNED CONSTANT VARCHAR2(30) := 'PLANNED';
28: c_PO CONSTANT VARCHAR2(30) := 'PO';
29: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
30: c_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
31: c_User CONSTANT VARCHAR2(30) := 'User';
32: c_EMAIL CONSTANT VARCHAR2(30) := 'EMAIL';
33:

Line 1130: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)

1126: FROM PO_HEADERS_ALL HEADER
1127: WHERE
1128: HEADER.org_id = SES.num2
1129: AND HEADER.segment1 = SES.index_char1
1130: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)
1131: AND HEADER.po_header_id <> SES.num1
1132: )
1133: OR
1134: -- Check for previously purged documents.

Line 1141: AND DELETED_HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)

1137: FROM PO_HISTORY_POS_ALL DELETED_HEADER
1138: WHERE
1139: DELETED_HEADER.org_id = SES.num2
1140: AND DELETED_HEADER.segment1 = SES.index_char1
1141: AND DELETED_HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)
1142: )
1143: OR
1144: -- Check for other in-memory documents.
1145: EXISTS

Line 1188: AND SES.char2 IN (c_STANDARD,c_BLANKET)

1184: ( SES.index_char2 = 'X'
1185: OR
1186: (
1187: l_check_sourcing_flag = 'I'
1188: AND SES.char2 IN (c_STANDARD,c_BLANKET)
1189: )
1190: )
1191: ;
1192: