APPS.PO_INQ_SV dependencies on STANDARD

Line 89: PROCEDURE get_po_doc_access_sec_level(x_standard_security OUT NOCOPY VARCHAR2,

85: PROCEDURE NAME: get_po_doc_access_sec_level()
86:
87: ===========================================================================*/
88:
89: PROCEDURE get_po_doc_access_sec_level(x_standard_security OUT NOCOPY VARCHAR2,
90: x_blanket_security OUT NOCOPY VARCHAR2,
91: x_contract_security OUT NOCOPY VARCHAR2,
92: x_planned_security OUT NOCOPY VARCHAR2,
93: x_blanket_rel_security OUT NOCOPY VARCHAR2,

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

132:
133: SELECT security_level_code, document_type_code, document_subtype
134: BULK COLLECT into l_sec_level_tbl, l_doc_type_code_tbl, l_doc_subtype_tbl
135: FROM po_document_types_b
136: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')
137: or (document_type_code = 'PA' and document_subtype = 'BLANKET')
138: or (document_type_code = 'PA' and document_subtype = 'CONTRACT')
139: or (document_type_code = 'PO' and document_subtype = 'PLANNED')
140: or (document_type_code = 'RELEASE' and document_subtype = 'BLANKET')

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

142: ;
143:
144: FOR i IN 1..l_sec_level_tbl.COUNT
145: LOOP
146: IF (l_doc_type_code_tbl(i) = 'PO' and l_doc_subtype_tbl(i) = 'STANDARD')
147: THEN x_standard_security := l_sec_level_tbl(i);
148: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'BLANKET')
149: THEN x_blanket_security := l_sec_level_tbl(i);
150: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'CONTRACT')

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

143:
144: FOR i IN 1..l_sec_level_tbl.COUNT
145: LOOP
146: IF (l_doc_type_code_tbl(i) = 'PO' and l_doc_subtype_tbl(i) = 'STANDARD')
147: THEN x_standard_security := l_sec_level_tbl(i);
148: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'BLANKET')
149: THEN x_blanket_security := l_sec_level_tbl(i);
150: ELSIF (l_doc_type_code_tbl(i) = 'PA' and l_doc_subtype_tbl(i) = 'CONTRACT')
151: THEN x_contract_security := l_sec_level_tbl(i);

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

207: l_progress := '000';
208:
209: -- : Add PREPAYMENT shipment type
210:
211: IF (x_shipment_type IN ('STANDARD', 'PLANNED', 'PREPAYMENT')) THEN
212: l_progress := '010';
213: l_doc_type := PO_INTG_DOCUMENT_FUNDS_GRP.g_doc_type_PO;
214: ELSIF (x_shipment_type IN ('BLANKET', 'SCHEDULED')) THEN
215: l_progress := '020';

Line 403: FROM bom_standard_operations bso,

399: BEGIN
400:
401: SELECT bso.operation_code
402: INTO x_wip_operation_code
403: FROM bom_standard_operations bso,
404: wip_operations wop
405: WHERE ( x_wip_rep_schedule_id IS NULL
406: OR wop.repetitive_schedule_id
407: = x_wip_rep_schedule_id)

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

407: = x_wip_rep_schedule_id)
408: AND wop.wip_entity_id = x_wip_entity_id
409: AND wop.organization_id = x_destination_org_id
410: AND wop.operation_seq_num = x_wip_operation_seq_num
411: AND wop.standard_operation_id = bso.standard_operation_id(+)
412: AND NVL(bso.organization_id,x_destination_org_id)
413: = x_destination_org_id;
414:
415: return(x_wip_operation_code);

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

720: /* Bug : 1056562 Reverting back to 10.7 status. We should be displaying
721: Released amount not agreed amount.
722: */
723:
724: if (x_type_lookup_code = 'STANDARD') then
725:
726: x_total_level := 'H';
727:
728: elsif (x_type_lookup_code = 'CONTRACT') then