APPS.PO_EXHIBITS_PVT dependencies on STANDARD

Line 1041: IF( p_document_type_tbl(i) IN ('PO_STANDARD', 'PA_CONTRACT', 'PA_BLANKET') ) THEN

1037: PO_LOG.stmt(d_module, d_position, 'p_document_id_tbl',
1038: p_document_id_tbl(i));
1039: END IF;
1040:
1041: IF( p_document_type_tbl(i) IN ('PO_STANDARD', 'PA_CONTRACT', 'PA_BLANKET') ) THEN
1042:
1043: BEGIN
1044: SELECT Nvl(is_cdrl,'N')
1045: INTO l_is_valid_exhibit

Line 1095: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN

1091: x_return_msg := 'EXHIBIT_NUM_USED_BY_ELIN';
1092: RETURN;
1093: END IF;
1094:
1095: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN
1096:
1097: BEGIN
1098: SELECT Nvl(is_cdrl, 'N')
1099: INTO l_is_valid_exhibit

Line 1230: IF( p_document_type_tbl(i) IN ('PO_STANDARD', 'PA_CONTRACT', 'PA_BLANKET') ) THEN

1226: PO_LOG.stmt(d_module, d_position, 'p_document_id_tbl',
1227: p_document_id_tbl(i));
1228: END IF;
1229:
1230: IF( p_document_type_tbl(i) IN ('PO_STANDARD', 'PA_CONTRACT', 'PA_BLANKET') ) THEN
1231:
1232: DELETE po_exhibit_details ex
1233: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1234: AND ex.po_header_id = p_document_id_tbl(i)

Line 1237: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN

1233: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1234: AND ex.po_header_id = p_document_id_tbl(i)
1235: AND ex.is_cdrl = p_is_cdrl_tbl(i);
1236:
1237: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN
1238:
1239: DELETE po_exhibit_details_draft mex
1240: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)
1241: AND mex.draft_id = p_document_id_tbl(i)

Line 1330: IF p_doc_sub_type = 'STANDARD' THEN

1326: END IF;
1327:
1328: IF( p_po_draft_id = -1 ) THEN
1329:
1330: IF p_doc_sub_type = 'STANDARD' THEN
1331: l_document_type := 'PO_STANDARD';
1332: ELSIF p_doc_sub_type = 'BLANKET' THEN
1333: l_document_type := 'PA_BLANKET';
1334: ELSE

Line 1331: l_document_type := 'PO_STANDARD';

1327:
1328: IF( p_po_draft_id = -1 ) THEN
1329:
1330: IF p_doc_sub_type = 'STANDARD' THEN
1331: l_document_type := 'PO_STANDARD';
1332: ELSIF p_doc_sub_type = 'BLANKET' THEN
1333: l_document_type := 'PA_BLANKET';
1334: ELSE
1335: l_document_type := 'PA_CONTRACT';

Line 1372: IF p_doc_sub_type = 'STANDARD' THEN

1368: AND exhibit_name = p_exhibit_name;
1369:
1370: ELSE
1371:
1372: IF p_doc_sub_type = 'STANDARD' THEN
1373: l_document_type := 'PO_STANDARD_MOD';
1374: ELSIF p_doc_sub_type = 'BLANKET' THEN
1375: l_document_type := 'PA_BLANKET_MOD';
1376: ELSE

Line 1373: l_document_type := 'PO_STANDARD_MOD';

1369:
1370: ELSE
1371:
1372: IF p_doc_sub_type = 'STANDARD' THEN
1373: l_document_type := 'PO_STANDARD_MOD';
1374: ELSIF p_doc_sub_type = 'BLANKET' THEN
1375: l_document_type := 'PA_BLANKET_MOD';
1376: ELSE
1377: l_document_type := 'PA_CONTRACT_MOD';

Line 1525: IF p_doc_sub_type = 'STANDARD' THEN

1521: END IF;
1522:
1523: IF( p_po_draft_id = -1 ) THEN
1524:
1525: IF p_doc_sub_type = 'STANDARD' THEN
1526: l_document_type := 'PO_STANDARD';
1527: ELSIF p_doc_sub_type = 'BLANKET' THEN
1528: l_document_type := 'PA_BLANKET';
1529: ELSE

Line 1526: l_document_type := 'PO_STANDARD';

1522:
1523: IF( p_po_draft_id = -1 ) THEN
1524:
1525: IF p_doc_sub_type = 'STANDARD' THEN
1526: l_document_type := 'PO_STANDARD';
1527: ELSIF p_doc_sub_type = 'BLANKET' THEN
1528: l_document_type := 'PA_BLANKET';
1529: ELSE
1530: l_document_type := 'PA_CONTRACT';

Line 1537: IF p_doc_sub_type = 'STANDARD' THEN

1533: l_docid := p_po_header_id;
1534:
1535: ELSE
1536:
1537: IF p_doc_sub_type = 'STANDARD' THEN
1538: l_document_type := 'PO_STANDARD_MOD';
1539: ELSIF p_doc_sub_type = 'BLANKET' THEN
1540: l_document_type := 'PA_BLANKET_MOD';
1541: ELSE

Line 1538: l_document_type := 'PO_STANDARD_MOD';

1534:
1535: ELSE
1536:
1537: IF p_doc_sub_type = 'STANDARD' THEN
1538: l_document_type := 'PO_STANDARD_MOD';
1539: ELSIF p_doc_sub_type = 'BLANKET' THEN
1540: l_document_type := 'PA_BLANKET_MOD';
1541: ELSE
1542: l_document_type := 'PA_CONTRACT_MOD';