DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_TBL_VARCHAR50

Line 3078: l_document_number_tbl PO_TBL_VARCHAR50;

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:
3082:

Line 3080: l_related_doc_number_tbl PO_TBL_VARCHAR50;

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
3084: IF PO_LOG.d_proc THEN

Line 3205: l_document_number_tbl PO_TBL_VARCHAR50;

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:
3209: BEGIN

Line 3207: l_related_doc_number_tbl PO_TBL_VARCHAR50;

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
3211: PO_LOG.proc_begin(d_mod,'p_request_id',p_request_id);

Line 3689: l_invoice_num_tbl PO_TBL_VARCHAR50;

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
3693: l_invoice_id NUMBER;

Line 4215: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50

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;
4219: d_position NUMBER := 0;

Line 4269: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50

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
4273: d_mod CONSTANT VARCHAR2(100) := D_prepd_inv_for_vndr_exists;

Line 4328: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50

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
4332: d_mod CONSTANT VARCHAR2(100) := D_partpd_inv_for_vndr_exists;