APPS.PO_INQ_SV dependencies on STANDARD

Line 127: PROCEDURE get_po_doc_access_sec_level(x_standard_security OUT NOCOPY VARCHAR2,

123: PROCEDURE NAME: get_po_doc_access_sec_level()
124:
125: ===========================================================================*/
126:
127: PROCEDURE get_po_doc_access_sec_level(x_standard_security OUT NOCOPY VARCHAR2,
128: x_blanket_security OUT NOCOPY VARCHAR2,
129: x_contract_security OUT NOCOPY VARCHAR2,
130: x_planned_security OUT NOCOPY VARCHAR2,
131: x_blanket_rel_security OUT NOCOPY VARCHAR2,

Line 174: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')

170:
171: SELECT security_level_code, document_type_code, document_subtype
172: BULK COLLECT into l_sec_level_tbl, l_doc_type_code_tbl, l_doc_subtype_tbl
173: FROM po_document_types_b
174: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')
175: or (document_type_code = 'PA' and document_subtype = 'BLANKET')
176: or (document_type_code = 'PA' and document_subtype = 'CONTRACT')
177: or (document_type_code = 'PO' and document_subtype = 'PLANNED')
178: or (document_type_code = 'RELEASE' and document_subtype = 'BLANKET')

Line 184: IF (l_doc_type_code_tbl(i) = 'PO' and l_doc_subtype_tbl(i) = 'STANDARD')

180: ;
181:
182: FOR i IN 1..l_sec_level_tbl.COUNT
183: LOOP
184: IF (l_doc_type_code_tbl(i) = 'PO' and l_doc_subtype_tbl(i) = 'STANDARD')
185: THEN x_standard_security := l_sec_level_tbl(i);
186: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'BLANKET')
187: THEN x_blanket_security := l_sec_level_tbl(i);
188: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'CONTRACT')

Line 185: THEN x_standard_security := l_sec_level_tbl(i);

181:
182: FOR i IN 1..l_sec_level_tbl.COUNT
183: LOOP
184: IF (l_doc_type_code_tbl(i) = 'PO' and l_doc_subtype_tbl(i) = 'STANDARD')
185: THEN x_standard_security := l_sec_level_tbl(i);
186: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'BLANKET')
187: THEN x_blanket_security := l_sec_level_tbl(i);
188: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'CONTRACT')
189: THEN x_contract_security := l_sec_level_tbl(i);

Line 249: IF (x_shipment_type IN ('STANDARD', 'PLANNED', 'PREPAYMENT')) THEN

245: l_progress := '000';
246:
247: -- : Add PREPAYMENT shipment type
248:
249: IF (x_shipment_type IN ('STANDARD', 'PLANNED', 'PREPAYMENT')) THEN
250: l_progress := '010';
251: l_doc_type := PO_INTG_DOCUMENT_FUNDS_GRP.g_doc_type_PO;
252: ELSIF (x_shipment_type IN ('BLANKET', 'SCHEDULED')) THEN
253: l_progress := '020';

Line 455: FROM bom_standard_operations bso,

451: BEGIN
452:
453: SELECT bso.operation_code
454: INTO x_wip_operation_code
455: FROM bom_standard_operations bso,
456: wip_operations wop
457: WHERE ( x_wip_rep_schedule_id IS NULL
458: OR wop.repetitive_schedule_id
459: = x_wip_rep_schedule_id)

Line 463: AND wop.standard_operation_id = bso.standard_operation_id(+)

459: = x_wip_rep_schedule_id)
460: AND wop.wip_entity_id = x_wip_entity_id
461: AND wop.organization_id = x_destination_org_id
462: AND wop.operation_seq_num = x_wip_operation_seq_num
463: AND wop.standard_operation_id = bso.standard_operation_id(+)
464: AND NVL(bso.organization_id,x_destination_org_id)
465: = x_destination_org_id;
466:
467: return(x_wip_operation_code);

Line 776: if (x_type_lookup_code = 'STANDARD') then

772: /* Bug : 1056562 Reverting back to 10.7 status. We should be displaying
773: Released amount not agreed amount.
774: */
775:
776: if (x_type_lookup_code = 'STANDARD') then
777:
778: x_total_level := 'H';
779:
780: elsif (x_type_lookup_code = 'CONTRACT') then