DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 259: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

255: -------------------------------------------------------------------------------
256: PROCEDURE validate_multi_mod( p_multi_mod_request_id IN NUMBER
257: ,p_validation_type IN VARCHAR2 DEFAULT NULL
258: ,x_result_type OUT NOCOPY VARCHAR2
259: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
260: )
261: is
262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;

Line 546: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

542: ,p_multi_mod_docs IN PO_MULTI_MOD_DOCS_VAL_TYPE
543: ,p_multi_mod_changes IN PO_MULTI_MOD_CHANGES_VAL_TYPE
544: ,p_validation_type IN VARCHAR2
545: ,x_result_type OUT NOCOPY VARCHAR2
546: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
547: )
548: is
549: d_mod CONSTANT VARCHAR2(100) := D_validate_set;
550: d_position NUMBER := 0;

Line 568: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

564: x_result_type := c_result_type_SUCCESS;
565: END IF;
566:
567: IF (x_results IS NULL) THEN
568: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
569: END IF;
570:
571: --loop through the validation set, performing each validation
572: FOR i IN 1 .. p_validation_set.COUNT LOOP

Line 928: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

924: ( p_request_id IN NUMBER
925: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
926: ,p_validation_type IN VARCHAR2
927: ,x_result_type OUT NOCOPY VARCHAR2
928: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
929: )
930: is
931: l_results_count NUMBER;
932: d_mod CONSTANT VARCHAR2(100) := D_atleast_one_doc_selected;

Line 945: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

941: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
942: END IF;
943:
944: IF (x_results IS NULL) THEN
945: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
946: END IF;
947:
948: d_position := 10;
949:

Line 1017: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1013: ,p_exemption_reason IN VARCHAR2
1014: ,p_initiate_app_flag IN VARCHAR2
1015: ,p_validation_type IN VARCHAR2
1016: ,x_result_type OUT NOCOPY VARCHAR2
1017: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1018: )
1019: is
1020: l_results_count NUMBER;
1021: d_mod CONSTANT VARCHAR2(100) := D_exemption_reason_given;

Line 1035: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1031: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1032: END IF;
1033:
1034: IF (x_results IS NULL) THEN
1035: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1036: END IF;
1037:
1038: d_position := 10;
1039:

Line 1128: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1124: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
1125: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER
1126: ,p_validation_type IN VARCHAR2
1127: ,x_result_type OUT NOCOPY VARCHAR2
1128: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1129: )
1130: is
1131: l_results_count NUMBER;
1132: d_mod CONSTANT VARCHAR2(100) := D_new_vendor_contact_provided;

Line 1152: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1148: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1149: END IF;
1150:
1151: IF (x_results IS NULL) THEN
1152: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1153: END IF;
1154:
1155: d_position := 10;
1156:

Line 1272: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1268: ,p_acceptance_reqd_flag IN VARCHAR2
1269: ,p_acceptance_due_date IN DATE
1270: ,p_validation_type IN VARCHAR2
1271: ,x_result_type OUT NOCOPY VARCHAR2
1272: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1273: )
1274: is
1275: l_results_count NUMBER;
1276: d_mod CONSTANT VARCHAR2(100) := D_acceptance_due_date_valid;

Line 1290: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1286: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1287: END IF;
1288:
1289: IF (x_results IS NULL) THEN
1290: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1291: END IF;
1292:
1293: l_results_count := x_results.result_type.COUNT;
1294: IF d_stmt THEN

Line 1360: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1356: ,p_acceptance_reqd_flag IN VARCHAR2
1357: ,p_clm_noofcopies IN NUMBER
1358: ,p_validation_type IN VARCHAR2
1359: ,x_result_type OUT NOCOPY VARCHAR2
1360: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1361: )
1362: is
1363: l_results_count NUMBER;
1364: d_mod CONSTANT VARCHAR2(100) := D_no_of_copies_ge_zero;

Line 1378: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1374: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1375: END IF;
1376:
1377: IF (x_results IS NULL) THEN
1378: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1379: END IF;
1380:
1381: l_results_count := x_results.result_type.COUNT;
1382: IF d_stmt THEN

Line 1455: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1451: ,p_old_vendor_name_tbl PO_TBL_VARCHAR240
1452: ,p_new_vendor_name_tbl PO_TBL_VARCHAR240
1453: ,p_validation_type IN VARCHAR2
1454: ,x_result_type OUT NOCOPY VARCHAR2
1455: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1456: )
1457: is
1458: l_results_count NUMBER;
1459: d_mod CONSTANT VARCHAR2(100) := D_vendor_name_chg_valid;

Line 1475: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1471: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1472: END IF;
1473:
1474: IF (x_results IS NULL) THEN
1475: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1476: END IF;
1477:
1478: l_results_count := x_results.result_type.COUNT;
1479: IF d_stmt THEN

Line 1560: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1556: ,p_old_vendor_id_tbl PO_TBL_NUMBER
1557: ,p_new_vendor_id_tbl PO_TBL_NUMBER
1558: ,p_validation_type IN VARCHAR2
1559: ,x_result_type OUT NOCOPY VARCHAR2
1560: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1561: )
1562: is
1563: l_results_count NUMBER;
1564: d_mod CONSTANT VARCHAR2(100) := D_vendor_chg_valid;

Line 1578: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1574: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1575: END IF;
1576:
1577: IF (x_results IS NULL) THEN
1578: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1579: END IF;
1580:
1581: l_results_count := x_results.result_type.COUNT;
1582: IF d_stmt THEN

Line 1661: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1657: ,p_change_type_tbl PO_TBL_VARCHAR30
1658: ,p_new_vendor_id_tbl PO_TBL_NUMBER
1659: ,p_validation_type IN VARCHAR2
1660: ,x_result_type OUT NOCOPY VARCHAR2
1661: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1662: )
1663: is
1664: l_results_count NUMBER;
1665: d_mod CONSTANT VARCHAR2(100) := D_new_vendor_on_hold;

Line 1680: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1676: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1677: END IF;
1678:
1679: IF (x_results IS NULL) THEN
1680: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1681: END IF;
1682:
1683: l_results_count := x_results.result_type.COUNT;
1684: IF d_stmt THEN

Line 1765: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1761: PROCEDURE clause_change_valid
1762: ( p_request_id IN NUMBER
1763: ,p_validation_type IN VARCHAR2
1764: ,x_result_type OUT NOCOPY VARCHAR2
1765: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1766: )
1767: is
1768: l_results_count NUMBER;
1769: d_mod CONSTANT VARCHAR2(100) := D_clause_change_valid;

Line 1782: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1778: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1779: END IF;
1780:
1781: IF (x_results IS NULL) THEN
1782: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1783: END IF;
1784:
1785: d_position := 10;
1786:

Line 1847: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1843: ( p_request_id IN NUMBER
1844: ,p_change_id_tbl IN PO_TBL_NUMBER
1845: ,p_validation_type IN VARCHAR2
1846: ,x_result_type OUT NOCOPY VARCHAR2
1847: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1848: )
1849: is
1850:
1851: l_results_count NUMBER;

Line 1868: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1864: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1865: END IF;
1866:
1867: IF (x_results IS NULL) THEN
1868: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1869: END IF;
1870:
1871: l_results_count := x_results.result_type.COUNT;
1872: IF d_stmt THEN

Line 1971: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

1967: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
1968: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
1969: ,p_validation_type IN VARCHAR2
1970: ,x_result_type OUT NOCOPY VARCHAR2
1971: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
1972: )
1973: is
1974: l_results_count NUMBER;
1975: d_mod CONSTANT VARCHAR2(100) := D_new_vendor_site_provided;

Line 1992: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

1988: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1989: END IF;
1990:
1991: IF (x_results IS NULL) THEN
1992: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
1993: END IF;
1994:
1995: d_position := 10;
1996:

Line 2080: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

2076: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
2077: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
2078: ,p_validation_type IN VARCHAR2
2079: ,x_result_type OUT NOCOPY VARCHAR2
2080: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
2081: )
2082: is
2083: l_results_count NUMBER;
2084: d_mod CONSTANT VARCHAR2(100) := D_new_vendor_site_CCR_valid;

Line 2104: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

2100: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
2101: END IF;
2102:
2103: IF (x_results IS NULL) THEN
2104: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
2105: END IF;
2106:
2107: d_position := 10;
2108:

Line 2216: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

2212: --End of Comments
2213: -------------------------------------------------------------------------------
2214: PROCEDURE uda_addresses_valid( p_request_id IN NUMBER
2215: ,x_result_type OUT NOCOPY VARCHAR2
2216: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
2217: )
2218: IS
2219: d_mod CONSTANT VARCHAR2(100) := D_uda_addresses_valid;
2220: d_position NUMBER := 0;

Line 2254: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

2250: PO_LOG.proc_begin(d_mod,'p_request_id',p_request_id);
2251: END IF;
2252:
2253: IF (x_results IS NULL) THEN
2254: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
2255: END IF;
2256:
2257: d_position := 10;
2258:

Line 2456: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

2452: ,p_clm_contract_officer IN NUMBER
2453: ,p_validation_type IN VARCHAR2
2454: ,p_org_id_tbl IN PO_TBL_NUMBER
2455: ,x_result_type OUT NOCOPY VARCHAR2
2456: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
2457: )
2458: is
2459: l_results_count NUMBER;
2460: l_ko_sign_required VARCHAR2(1);

Line 2474: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

2470: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
2471: END IF;
2472:
2473: IF (x_results IS NULL) THEN
2474: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
2475: END IF;
2476:
2477: l_results_count := x_results.result_type.COUNT;
2478: IF d_stmt THEN

Line 2757: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)

2753: --End of Comments
2754: -------------------------------------------------------------------------------
2755: PROCEDURE header_lock_compatible(p_request_id IN NUMBER
2756: , x_result_type OUT NOCOPY VARCHAR2
2757: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)
2758: IS
2759: l_header_lock VARCHAR2(1) := 'N';
2760: l_document_id_tbl PO_TBL_NUMBER;
2761: l_results_count NUMBER;

Line 2845: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)

2841: --End of Comments
2842: -------------------------------------------------------------------------------
2843: PROCEDURE address_lock_compatible(p_request_id IN NUMBER
2844: , x_result_type OUT NOCOPY VARCHAR2
2845: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)
2846: IS
2847: d_position NUMBER := 0;
2848: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
2849: d_mod CONSTANT VARCHAR2(2000) := D_address_lock_compatible;

Line 2976: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)

2972: --End of Comments
2973: -------------------------------------------------------------------------------
2974: PROCEDURE validate_open_mod(p_request_id IN NUMBER
2975: , x_result_type OUT NOCOPY VARCHAR2
2976: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE)
2977: IS
2978: d_mod CONSTANT VARCHAR2(2000) := D_validate_open_mod;
2979: l_document_num_tbl PO_TBL_VARCHAR100;
2980: l_conc_mod_flag_tbl PO_TBL_VARCHAR1;

Line 3070: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

3066: ( p_request_id IN NUMBER
3067: -- ,p_document_id_tbl IN PO_TBL_NUMBER
3068: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
3069: ,x_result_type OUT NOCOPY VARCHAR2
3070: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
3071: )
3072: is
3073: l_results_count NUMBER;
3074: d_mod CONSTANT VARCHAR2(100) := D_generate_idv_exceptions;

Line 3092: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

3088: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3089: END IF;
3090:
3091: IF (x_results IS NULL) THEN
3092: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
3093: END IF;
3094:
3095: d_position := 10;
3096:

Line 3192: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

3188: ( p_request_id IN NUMBER
3189: -- ,p_document_id_tbl IN PO_TBL_NUMBER
3190: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
3191: ,x_result_type OUT NOCOPY VARCHAR2
3192: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
3193: )
3194: is
3195: l_results_count NUMBER;
3196: d_mod CONSTANT VARCHAR2(100) := D_generate_award_exceptions;

Line 3218: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

3214: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3215: END IF;
3216:
3217: IF (x_results IS NULL) THEN
3218: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
3219: END IF;
3220:
3221: d_position := 10;
3222:

Line 3318: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

3314: ,p_document_id_tbl IN PO_TBL_NUMBER
3315: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
3316: ,p_novation_effective_date IN DATE
3317: ,x_result_type OUT NOCOPY VARCHAR2
3318: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
3319: )
3320: is
3321: l_results_count NUMBER;
3322: d_mod CONSTANT VARCHAR2(100) := D_generate_receipts_exceptions;

Line 3338: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3334: l_unval_invoice_exists VARCHAR2(1);
3335: l_receipt_date DATE;
3336: l_receipt_amount NUMBER;
3337: l_vendor_id NUMBER;
3338: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3339: l_return_status VARCHAR2(10);
3340: l_error_msg VARCHAR2(100);
3341:
3342: BEGIN

Line 3351: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

3347: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3348: END IF;
3349:
3350: IF (x_results IS NULL) THEN
3351: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
3352: END IF;
3353:
3354: d_position := 10;
3355:

Line 3681: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

3677: ,p_document_id_tbl IN PO_TBL_NUMBER
3678: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
3679: ,p_novation_effective_date IN DATE
3680: ,x_result_type OUT NOCOPY VARCHAR2
3681: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
3682: )
3683: is
3684: l_results_count NUMBER;
3685: d_mod CONSTANT VARCHAR2(100) := D_generate_invoice_exceptions;

Line 3710: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

3706: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3707: END IF;
3708:
3709: IF (x_results IS NULL) THEN
3710: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
3711: END IF;
3712:
3713: d_position := 10;
3714:

Line 4444: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

4440: ,p_document_id_tbl IN PO_TBL_NUMBER
4441: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
4442: ,p_novation_effective_date IN DATE
4443: ,x_result_type OUT NOCOPY VARCHAR2
4444: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
4445: )
4446: is
4447: l_results_count NUMBER;
4448: d_mod CONSTANT VARCHAR2(100) := D_generate_project_exceptions;

Line 4464: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();

4460: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
4461: END IF;
4462:
4463: IF (x_results IS NULL) THEN
4464: x_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.new_instance();
4465: END IF;
4466:
4467: d_position := 10;
4468:

Line 4552: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

4548: IS
4549: d_mod CONSTANT VARCHAR2(100) := D_generate_supp_chg_exceptions;
4550: d_position NUMBER := 0;
4551: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
4552: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
4553: l_result_type VARCHAR2(30);
4554: BEGIN
4555: IF PO_LOG.d_proc THEN
4556: PO_LOG.proc_begin(d_mod,'p_request_id',p_multi_mod_request_id);