eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_TBL_NUMBER

Line 925: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

921: --End of Comments
922: -------------------------------------------------------------------------------
923: PROCEDURE atleast_one_doc_selected
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: )

Line 1119: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

1115: -------------------------------------------------------------------------------
1116: PROCEDURE new_vendor_contact_provided
1117: ( p_request_id IN NUMBER
1118: ,p_acceptance_reqd_flag IN VARCHAR2
1119: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
1120: ,p_document_id_tbl IN PO_TBL_NUMBER
1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER

Line 1120: ,p_document_id_tbl IN PO_TBL_NUMBER

1116: PROCEDURE new_vendor_contact_provided
1117: ( p_request_id IN NUMBER
1118: ,p_acceptance_reqd_flag IN VARCHAR2
1119: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
1120: ,p_document_id_tbl IN PO_TBL_NUMBER
1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER
1124: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 1121: ,p_change_id_tbl IN PO_TBL_NUMBER

1117: ( p_request_id IN NUMBER
1118: ,p_acceptance_reqd_flag IN VARCHAR2
1119: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
1120: ,p_document_id_tbl IN PO_TBL_NUMBER
1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER
1124: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
1125: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER

Line 1123: ,p_org_id_tbl IN PO_TBL_NUMBER

1119: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
1120: ,p_document_id_tbl IN PO_TBL_NUMBER
1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER
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

Line 1124: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

1120: ,p_document_id_tbl IN PO_TBL_NUMBER
1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER
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

Line 1125: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER

1121: ,p_change_id_tbl IN PO_TBL_NUMBER
1122: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1123: ,p_org_id_tbl IN PO_TBL_NUMBER
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: )

Line 1449: ,p_change_id_tbl PO_TBL_NUMBER

1445: -------------------------------------------------------------------------------
1446:
1447: PROCEDURE vendor_name_chg_valid
1448: ( p_request_id IN NUMBER
1449: ,p_change_id_tbl PO_TBL_NUMBER
1450: ,p_change_type_tbl PO_TBL_VARCHAR30
1451: ,p_old_vendor_name_tbl PO_TBL_VARCHAR240
1452: ,p_new_vendor_name_tbl PO_TBL_VARCHAR240
1453: ,p_validation_type IN VARCHAR2

Line 1554: ,p_change_id_tbl PO_TBL_NUMBER

1550: -------------------------------------------------------------------------------
1551:
1552: PROCEDURE vendor_chg_valid
1553: ( p_request_id IN NUMBER
1554: ,p_change_id_tbl PO_TBL_NUMBER
1555: ,p_change_type_tbl PO_TBL_VARCHAR30
1556: ,p_old_vendor_id_tbl PO_TBL_NUMBER
1557: ,p_new_vendor_id_tbl PO_TBL_NUMBER
1558: ,p_validation_type IN VARCHAR2

Line 1556: ,p_old_vendor_id_tbl PO_TBL_NUMBER

1552: PROCEDURE vendor_chg_valid
1553: ( p_request_id IN NUMBER
1554: ,p_change_id_tbl PO_TBL_NUMBER
1555: ,p_change_type_tbl PO_TBL_VARCHAR30
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

Line 1557: ,p_new_vendor_id_tbl PO_TBL_NUMBER

1553: ( p_request_id IN NUMBER
1554: ,p_change_id_tbl PO_TBL_NUMBER
1555: ,p_change_type_tbl PO_TBL_VARCHAR30
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: )

Line 1656: ,p_change_id_tbl PO_TBL_NUMBER

1652: -------------------------------------------------------------------------------
1653:
1654: PROCEDURE new_vendor_on_hold
1655: ( p_request_id IN NUMBER
1656: ,p_change_id_tbl PO_TBL_NUMBER
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

Line 1658: ,p_new_vendor_id_tbl PO_TBL_NUMBER

1654: PROCEDURE new_vendor_on_hold
1655: ( p_request_id IN NUMBER
1656: ,p_change_id_tbl PO_TBL_NUMBER
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: )

Line 1844: ,p_change_id_tbl IN PO_TBL_NUMBER

1840: --End of Comments
1841: -------------------------------------------------------------------------------
1842: PROCEDURE atleast_one_change_done
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: )

Line 1964: ,p_change_id_tbl IN PO_TBL_NUMBER

1960: --End of Comments
1961: -------------------------------------------------------------------------------
1962: PROCEDURE new_vendor_site_provided
1963: ( p_request_id IN NUMBER
1964: ,p_change_id_tbl IN PO_TBL_NUMBER
1965: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1966: ,p_org_id_tbl IN PO_TBL_NUMBER
1967: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
1968: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 1966: ,p_org_id_tbl IN PO_TBL_NUMBER

1962: PROCEDURE new_vendor_site_provided
1963: ( p_request_id IN NUMBER
1964: ,p_change_id_tbl IN PO_TBL_NUMBER
1965: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1966: ,p_org_id_tbl IN PO_TBL_NUMBER
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

Line 1967: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER

1963: ( p_request_id IN NUMBER
1964: ,p_change_id_tbl IN PO_TBL_NUMBER
1965: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1966: ,p_org_id_tbl IN PO_TBL_NUMBER
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

Line 1968: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

1964: ,p_change_id_tbl IN PO_TBL_NUMBER
1965: ,p_change_type_tbl IN PO_TBL_VARCHAR30
1966: ,p_org_id_tbl IN PO_TBL_NUMBER
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: )

Line 2074: ,p_change_id_tbl IN PO_TBL_NUMBER

2070: --End of Comments
2071: -------------------------------------------------------------------------------
2072: PROCEDURE new_vendor_site_CCR_valid
2073: ( p_request_id IN NUMBER
2074: ,p_change_id_tbl IN PO_TBL_NUMBER
2075: ,p_change_type_tbl IN PO_TBL_VARCHAR30
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

Line 2076: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER

2072: PROCEDURE new_vendor_site_CCR_valid
2073: ( p_request_id IN NUMBER
2074: ,p_change_id_tbl IN PO_TBL_NUMBER
2075: ,p_change_type_tbl IN PO_TBL_VARCHAR30
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

Line 2077: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

2073: ( p_request_id IN NUMBER
2074: ,p_change_id_tbl IN PO_TBL_NUMBER
2075: ,p_change_type_tbl IN PO_TBL_VARCHAR30
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: )

Line 2454: ,p_org_id_tbl IN PO_TBL_NUMBER

2450: PROCEDURE contract_officer_provided
2451: ( p_request_id IN NUMBER
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

Line 2684: ,p_change_id_tbl IN PO_TBL_NUMBER)

2680: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
2681: --End of Comments
2682: -------------------------------------------------------------------------------
2683: FUNCTION has_vendor_changed(p_request_id IN NUMBER
2684: ,p_change_id_tbl IN PO_TBL_NUMBER)
2685: RETURN VARCHAR2
2686: IS
2687: l_has_vendor_changed VARCHAR2(1) := 'N';
2688: d_mod CONSTANT VARCHAR2(100) := D_has_vendor_changed;

Line 2760: l_document_id_tbl PO_TBL_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;
2762: d_mod CONSTANT VARCHAR2(100) := D_header_lock_compatible;
2763: d_position NUMBER := 0;
2764: l_document_num_tbl PO_TBL_VARCHAR100;

Line 2852: l_sum_check_tbl PO_TBL_NUMBER;

2848: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
2849: d_mod CONSTANT VARCHAR2(2000) := D_address_lock_compatible;
2850: l_addr_attr_group_id NUMBER;
2851: l_address_code_tbl PO_TBL_VARCHAR2000;
2852: l_sum_check_tbl PO_TBL_NUMBER;
2853: l_document_id_tbl PO_TBL_NUMBER;
2854: l_modification_number_tbl PO_TBL_VARCHAR100;
2855: l_document_number_tbl PO_TBL_VARCHAR100;
2856: l_results_count NUMBER;

Line 2853: l_document_id_tbl PO_TBL_NUMBER;

2849: d_mod CONSTANT VARCHAR2(2000) := D_address_lock_compatible;
2850: l_addr_attr_group_id NUMBER;
2851: l_address_code_tbl PO_TBL_VARCHAR2000;
2852: l_sum_check_tbl PO_TBL_NUMBER;
2853: l_document_id_tbl PO_TBL_NUMBER;
2854: l_modification_number_tbl PO_TBL_VARCHAR100;
2855: l_document_number_tbl PO_TBL_VARCHAR100;
2856: l_results_count NUMBER;
2857: BEGIN

Line 2981: l_document_id_tbl PO_TBL_NUMBER;

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;
2981: l_document_id_tbl PO_TBL_NUMBER;
2982: l_mod_exists VARCHAR2(1);
2983: d_position NUMBER := 0;
2984: l_results_count NUMBER;
2985: BEGIN

Line 3067: -- ,p_document_id_tbl IN PO_TBL_NUMBER

3063: --End of Comments
3064: -------------------------------------------------------------------------------
3065: PROCEDURE generate_idv_exceptions
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: )

Line 3068: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

3064: -------------------------------------------------------------------------------
3065: PROCEDURE generate_idv_exceptions
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

Line 3077: l_document_id_tbl PO_TBL_NUMBER;

3073: l_results_count NUMBER;
3074: d_mod CONSTANT VARCHAR2(100) := D_generate_idv_exceptions;
3075: d_position NUMBER := 0;
3076: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3077: l_document_id_tbl PO_TBL_NUMBER;
3078: l_document_number_tbl PO_TBL_VARCHAR50;
3079: l_related_document_id_tbl PO_TBL_NUMBER;
3080: l_related_doc_number_tbl PO_TBL_VARCHAR50;
3081:

Line 3079: l_related_document_id_tbl PO_TBL_NUMBER;

3075: d_position NUMBER := 0;
3076: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3077: l_document_id_tbl PO_TBL_NUMBER;
3078: l_document_number_tbl PO_TBL_VARCHAR50;
3079: l_related_document_id_tbl PO_TBL_NUMBER;
3080: l_related_doc_number_tbl PO_TBL_VARCHAR50;
3081:
3082:
3083: BEGIN

Line 3189: -- ,p_document_id_tbl IN PO_TBL_NUMBER

3185: --End of Comments
3186: -------------------------------------------------------------------------------
3187: PROCEDURE generate_award_exceptions
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: )

Line 3190: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

3186: -------------------------------------------------------------------------------
3187: PROCEDURE generate_award_exceptions
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

Line 3204: l_document_id_tbl PO_TBL_NUMBER;

3200: l_clm_source_document_id PO_HEADERS_ALL.clm_source_document_id%TYPE;
3201: l_idv_exists VARCHAR2(1) := 'N';
3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/
3204: l_document_id_tbl PO_TBL_NUMBER;
3205: l_document_number_tbl PO_TBL_VARCHAR50;
3206: l_related_document_id_tbl PO_TBL_NUMBER;
3207: l_related_doc_number_tbl PO_TBL_VARCHAR50;
3208:

Line 3206: l_related_document_id_tbl PO_TBL_NUMBER;

3202: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3203: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;*/
3204: l_document_id_tbl PO_TBL_NUMBER;
3205: l_document_number_tbl PO_TBL_VARCHAR50;
3206: l_related_document_id_tbl PO_TBL_NUMBER;
3207: l_related_doc_number_tbl PO_TBL_VARCHAR50;
3208:
3209: BEGIN
3210: IF PO_LOG.d_proc THEN

Line 3314: ,p_document_id_tbl IN PO_TBL_NUMBER

3310: --End of Comments
3311: -------------------------------------------------------------------------------
3312: PROCEDURE generate_receipts_exceptions
3313: ( p_request_id IN NUMBER
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

Line 3315: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

3311: -------------------------------------------------------------------------------
3312: PROCEDURE generate_receipts_exceptions
3313: ( p_request_id IN NUMBER
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: )

Line 3328: l_shipment_line_id_tbl PO_TBL_NUMBER;

3324: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3325: l_match_option PO_LINE_LOCATIONS_ALL.match_option%TYPE;
3326: l_inspection_required_flag PO_LINE_LOCATIONS_ALL.inspection_required_flag%TYPE;
3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;
3328: l_shipment_line_id_tbl PO_TBL_NUMBER;
3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;
3330: l_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;
3331: l_invoice_id AP_INVOICE_LINES_ALL.invoice_id%TYPE;
3332: l_match_exists VARCHAR2(1);

Line 3677: ,p_document_id_tbl IN PO_TBL_NUMBER

3673: --End of Comments
3674: -------------------------------------------------------------------------------
3675: PROCEDURE generate_invoice_exceptions
3676: ( p_request_id IN NUMBER
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

Line 3678: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

3674: -------------------------------------------------------------------------------
3675: PROCEDURE generate_invoice_exceptions
3676: ( p_request_id IN NUMBER
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: )

Line 3688: l_invoice_id_tbl PO_TBL_NUMBER;

3684: l_results_count NUMBER;
3685: d_mod CONSTANT VARCHAR2(100) := D_generate_invoice_exceptions;
3686: d_position NUMBER := 0;
3687: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3688: l_invoice_id_tbl PO_TBL_NUMBER;
3689: l_invoice_num_tbl PO_TBL_VARCHAR50;
3690: l_invoice_date_tbl PO_TBL_DATE;
3691: l_invoice_amount_tbl PO_TBL_NUMBER;
3692: --bug13084712

Line 3691: l_invoice_amount_tbl PO_TBL_NUMBER;

3687: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3688: l_invoice_id_tbl PO_TBL_NUMBER;
3689: l_invoice_num_tbl PO_TBL_VARCHAR50;
3690: l_invoice_date_tbl PO_TBL_DATE;
3691: l_invoice_amount_tbl PO_TBL_NUMBER;
3692: --bug13084712
3693: l_invoice_id NUMBER;
3694: l_invoice_num VARCHAR2(50);
3695: l_invoice_date DATE;

Line 4214: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4210: -------------------------------------------------------------------------------
4211:
4212: PROCEDURE unmtch_inv_for_vndr_exists( p_vendor_id IN NUMBER
4213: --bug13084712
4214: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4215: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
4216: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE)
4217: IS
4218: d_mod CONSTANT VARCHAR2(100) := D_unmtch_inv_for_vndr_exists;

Line 4268: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4264: -------------------------------------------------------------------------------
4265:
4266: PROCEDURE prepd_inv_for_vndr_exists( p_vendor_id IN NUMBER
4267: --bug13084712
4268: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4269: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
4270: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE)
4271:
4272: IS

Line 4327: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4323: -------------------------------------------------------------------------------
4324:
4325: PROCEDURE partpd_inv_for_vndr_exists( p_vendor_id IN NUMBER
4326: --bug13084712
4327: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4328: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
4329: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE)
4330:
4331: IS

Line 4440: ,p_document_id_tbl IN PO_TBL_NUMBER

4436: --End of Comments
4437: -------------------------------------------------------------------------------
4438: PROCEDURE generate_project_exceptions
4439: ( p_request_id IN NUMBER
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

Line 4441: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

4437: -------------------------------------------------------------------------------
4438: PROCEDURE generate_project_exceptions
4439: ( p_request_id IN NUMBER
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: )