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.PN_EXP_TO_AP dependencies on DBMS_SQL

Line 270: -- variables for dbms_sql

266: BAD_ITEM_EXCEPTION EXCEPTION;
267: BAD_INVOICE_NUM EXCEPTION;
268: FATAL_ERROR EXCEPTION;
269:
270: -- variables for dbms_sql
271: l_cursor INTEGER;
272: l_rows INTEGER;
273: l_count INTEGER;
274: l_cursor_2 INTEGER;

Line 492: dbms_sql.bind_variable

488: BEGIN
489:
490: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (+)');
491:
492: dbms_sql.bind_variable
493: (p_cursor,'l_one',l_one );
494: dbms_sql.bind_variable
495: (p_cursor,'l_id',l_id );
496:

Line 494: dbms_sql.bind_variable

490: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (+)');
491:
492: dbms_sql.bind_variable
493: (p_cursor,'l_one',l_one );
494: dbms_sql.bind_variable
495: (p_cursor,'l_id',l_id );
496:
497: IF p_grp_param IS NULL THEN
498:

Line 500: dbms_sql.bind_variable

496:
497: IF p_grp_param IS NULL THEN
498:
499: IF p_lease_num_low IS NOT NULL AND p_lease_num_high IS NOT NULL THEN
500: dbms_sql.bind_variable
501: (p_cursor,'l_lease_num_low',p_lease_num_low );
502: dbms_sql.bind_variable
503: (p_cursor,'l_lease_num_high',p_lease_num_high );
504:

Line 502: dbms_sql.bind_variable

498:
499: IF p_lease_num_low IS NOT NULL AND p_lease_num_high IS NOT NULL THEN
500: dbms_sql.bind_variable
501: (p_cursor,'l_lease_num_low',p_lease_num_low );
502: dbms_sql.bind_variable
503: (p_cursor,'l_lease_num_high',p_lease_num_high );
504:
505: ELSIF p_lease_num_low IS NULL AND p_lease_num_high IS NOT NULL THEN
506: dbms_sql.bind_variable

Line 506: dbms_sql.bind_variable

502: dbms_sql.bind_variable
503: (p_cursor,'l_lease_num_high',p_lease_num_high );
504:
505: ELSIF p_lease_num_low IS NULL AND p_lease_num_high IS NOT NULL THEN
506: dbms_sql.bind_variable
507: (p_cursor,'l_lease_num_high',p_lease_num_high );
508:
509: ELSIF p_lease_num_low IS NOT NULL AND p_lease_num_high IS NULL THEN
510: dbms_sql.bind_variable

Line 510: dbms_sql.bind_variable

506: dbms_sql.bind_variable
507: (p_cursor,'l_lease_num_high',p_lease_num_high );
508:
509: ELSIF p_lease_num_low IS NOT NULL AND p_lease_num_high IS NULL THEN
510: dbms_sql.bind_variable
511: (p_cursor,'l_lease_num_low',p_lease_num_low );
512: END IF;
513:
514: IF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NOT NULL THEN

Line 515: dbms_sql.bind_variable

511: (p_cursor,'l_lease_num_low',p_lease_num_low );
512: END IF;
513:
514: IF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NOT NULL THEN
515: dbms_sql.bind_variable
516: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
517: dbms_sql.bind_variable
518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:

Line 517: dbms_sql.bind_variable

513:
514: IF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NOT NULL THEN
515: dbms_sql.bind_variable
516: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
517: dbms_sql.bind_variable
518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:
520: ELSIF p_sch_dt_low IS NULL AND p_sch_dt_high IS NOT NULL THEN
521: dbms_sql.bind_variable

Line 521: dbms_sql.bind_variable

517: dbms_sql.bind_variable
518: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
519:
520: ELSIF p_sch_dt_low IS NULL AND p_sch_dt_high IS NOT NULL THEN
521: dbms_sql.bind_variable
522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
523:
524: ELSIF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NULL THEN
525: dbms_sql.bind_variable

Line 525: dbms_sql.bind_variable

521: dbms_sql.bind_variable
522: (p_cursor,'l_sch_dt_high',fnd_date.canonical_to_date(p_sch_dt_high) );
523:
524: ELSIF p_sch_dt_low IS NOT NULL AND p_sch_dt_high IS NULL THEN
525: dbms_sql.bind_variable
526: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
527: END IF;
528:
529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN

Line 530: dbms_sql.bind_variable

526: (p_cursor,'l_sch_dt_low',fnd_date.canonical_to_date(p_sch_dt_low) );
527: END IF;
528:
529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN
530: dbms_sql.bind_variable
531: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
532: dbms_sql.bind_variable
533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:

Line 532: dbms_sql.bind_variable

528:
529: IF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NOT NULL THEN
530: dbms_sql.bind_variable
531: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
532: dbms_sql.bind_variable
533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:
535: ELSIF p_due_dt_low IS NULL AND p_due_dt_high IS NOT NULL THEN
536: dbms_sql.bind_variable

Line 536: dbms_sql.bind_variable

532: dbms_sql.bind_variable
533: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
534:
535: ELSIF p_due_dt_low IS NULL AND p_due_dt_high IS NOT NULL THEN
536: dbms_sql.bind_variable
537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
538:
539: ELSIF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NULL THEN
540: dbms_sql.bind_variable

Line 540: dbms_sql.bind_variable

536: dbms_sql.bind_variable
537: (p_cursor,'l_due_dt_high',fnd_date.canonical_to_date(p_due_dt_high) );
538:
539: ELSIF p_due_dt_low IS NOT NULL AND p_due_dt_high IS NULL THEN
540: dbms_sql.bind_variable
541: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
542: END IF;
543:
544: IF p_pay_prps_code IS NOT NULL THEN

Line 545: dbms_sql.bind_variable

541: (p_cursor,'l_due_dt_low',fnd_date.canonical_to_date(p_due_dt_low) );
542: END IF;
543:
544: IF p_pay_prps_code IS NOT NULL THEN
545: dbms_sql.bind_variable
546: (p_cursor,'l_pay_prps_code',p_pay_prps_code );
547: END IF;
548:
549: IF p_prd_name IS NOT NULL THEN

Line 550: dbms_sql.bind_variable

546: (p_cursor,'l_pay_prps_code',p_pay_prps_code );
547: END IF;
548:
549: IF p_prd_name IS NOT NULL THEN
550: dbms_sql.bind_variable
551: (p_cursor,'l_prd_name',p_prd_name );
552: END IF;
553:
554: IF p_amt_low IS NOT NULL AND p_amt_high IS NOT NULL THEN

Line 555: dbms_sql.bind_variable

551: (p_cursor,'l_prd_name',p_prd_name );
552: END IF;
553:
554: IF p_amt_low IS NOT NULL AND p_amt_high IS NOT NULL THEN
555: dbms_sql.bind_variable
556: (p_cursor,'l_amt_low',p_amt_low );
557: dbms_sql.bind_variable
558: (p_cursor,'l_amt_high',p_amt_high );
559:

Line 557: dbms_sql.bind_variable

553:
554: IF p_amt_low IS NOT NULL AND p_amt_high IS NOT NULL THEN
555: dbms_sql.bind_variable
556: (p_cursor,'l_amt_low',p_amt_low );
557: dbms_sql.bind_variable
558: (p_cursor,'l_amt_high',p_amt_high );
559:
560: ELSIF p_amt_low IS NULL AND p_amt_high IS NOT NULL THEN
561: dbms_sql.bind_variable

Line 561: dbms_sql.bind_variable

557: dbms_sql.bind_variable
558: (p_cursor,'l_amt_high',p_amt_high );
559:
560: ELSIF p_amt_low IS NULL AND p_amt_high IS NOT NULL THEN
561: dbms_sql.bind_variable
562: (p_cursor,'l_amt_high',p_amt_high );
563:
564: ELSIF p_amt_low IS NOT NULL AND p_amt_high IS NULL THEN
565: dbms_sql.bind_variable

Line 565: dbms_sql.bind_variable

561: dbms_sql.bind_variable
562: (p_cursor,'l_amt_high',p_amt_high );
563:
564: ELSIF p_amt_low IS NOT NULL AND p_amt_high IS NULL THEN
565: dbms_sql.bind_variable
566: (p_cursor,'l_amt_low',p_amt_low );
567: END IF;
568:
569: IF p_vendor_id IS NOT NULL THEN

Line 570: dbms_sql.bind_variable

566: (p_cursor,'l_amt_low',p_amt_low );
567: END IF;
568:
569: IF p_vendor_id IS NOT NULL THEN
570: dbms_sql.bind_variable
571: (p_cursor,'l_vendor_id',p_vendor_id );
572: END IF;
573:
574: IF p_inv_num IS NOT NULL THEN

Line 575: dbms_sql.bind_variable

571: (p_cursor,'l_vendor_id',p_vendor_id );
572: END IF;
573:
574: IF p_inv_num IS NOT NULL THEN
575: dbms_sql.bind_variable
576: (p_cursor,'l_inv_num',p_inv_num );
577: END IF;
578:
579: ELSE

Line 580: dbms_sql.bind_variable

576: (p_cursor,'l_inv_num',p_inv_num );
577: END IF;
578:
579: ELSE
580: dbms_sql.bind_variable
581: (p_cursor,'l_grp_param',p_grp_param );
582: END IF;
583:
584: PNP_DEBUG_PKG.log('pn_exp_to_ap.bind_variables_to_cursor (-)');

Line 613: -- 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.

609: -- 22-NOV-04 Kiran o Fixed validations for terms distributions
610: -- 19-NOV-04 Anand o Bug # 4015081 - invoice number should be unique for a
611: -- a vendor - org_id combination.
612: -- 15-JUN-05 Kiran o Bug # 4303846 Used exceptions to handle errors.
613: -- 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
614: -- 30-NOV-05 Hareesha o Code changes for LE uptake.
615: --------------------------------------------------------------------------------
616: PROCEDURE cache_exp_items (p_lease_num_low VARCHAR2,
617: p_lease_num_high VARCHAR2,

Line 716: l_cursor := dbms_sql.open_cursor;

712: exp_ap_cache.DELETE;
713: l_index := 0;
714: l_index_2 := 0;
715:
716: l_cursor := dbms_sql.open_cursor;
717:
718: dbms_sql.parse(l_cursor, Q_Payitem, dbms_sql.native);
719:
720: bind_variables_to_cursor(p_lease_num_low,

Line 718: dbms_sql.parse(l_cursor, Q_Payitem, dbms_sql.native);

714: l_index_2 := 0;
715:
716: l_cursor := dbms_sql.open_cursor;
717:
718: dbms_sql.parse(l_cursor, Q_Payitem, dbms_sql.native);
719:
720: bind_variables_to_cursor(p_lease_num_low,
721: p_lease_num_high,
722: p_sch_dt_low,

Line 746: l_cursor_2 := dbms_sql.open_cursor;

742:
743: term_ID_tbl.DELETE;
744: LE_tbl.DELETE;
745:
746: l_cursor_2 := dbms_sql.open_cursor;
747: dbms_sql.parse(l_cursor_2, Q_Payitem1, dbms_sql.native);
748:
749: pnp_debug_pkg.log('Q_Payitem1:'||Q_Payitem1);
750:

Line 747: dbms_sql.parse(l_cursor_2, Q_Payitem1, dbms_sql.native);

743: term_ID_tbl.DELETE;
744: LE_tbl.DELETE;
745:
746: l_cursor_2 := dbms_sql.open_cursor;
747: dbms_sql.parse(l_cursor_2, Q_Payitem1, dbms_sql.native);
748:
749: pnp_debug_pkg.log('Q_Payitem1:'||Q_Payitem1);
750:
751: bind_variables_to_cursor(p_lease_num_low,

Line 766: l_rows_2 := dbms_sql.execute(l_cursor_2);

762: p_inv_num,
763: p_grp_param,
764: l_cursor_2);
765:
766: l_rows_2 := dbms_sql.execute(l_cursor_2);
767:
768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);
769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);
770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);

Line 768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);

764: l_cursor_2);
765:
766: l_rows_2 := dbms_sql.execute(l_cursor_2);
767:
768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);
769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);
770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);
771: dbms_sql.define_column (l_cursor_2, 4, v_org_id);
772:

Line 769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);

765:
766: l_rows_2 := dbms_sql.execute(l_cursor_2);
767:
768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);
769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);
770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);
771: dbms_sql.define_column (l_cursor_2, 4, v_org_id);
772:
773:

Line 770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);

766: l_rows_2 := dbms_sql.execute(l_cursor_2);
767:
768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);
769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);
770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);
771: dbms_sql.define_column (l_cursor_2, 4, v_org_id);
772:
773:
774: LOOP

Line 771: dbms_sql.define_column (l_cursor_2, 4, v_org_id);

767:
768: dbms_sql.define_column (l_cursor_2, 1, v_pn_payment_term_id);
769: dbms_sql.define_column (l_cursor_2, 2, v_pn_vendor_site_id);
770: dbms_sql.define_column (l_cursor_2, 3, v_pn_lia_account);
771: dbms_sql.define_column (l_cursor_2, 4, v_org_id);
772:
773:
774: LOOP
775:

Line 776: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );

772:
773:
774: LOOP
775:
776: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
777: EXIT WHEN l_count_2 <> 1;
778:
779: l_index_2 := l_index_2 + 1;
780:

Line 781: dbms_sql.column_value (l_cursor_2, 1, term_ID_tbl(l_index_2));

777: EXIT WHEN l_count_2 <> 1;
778:
779: l_index_2 := l_index_2 + 1;
780:
781: dbms_sql.column_value (l_cursor_2, 1, term_ID_tbl(l_index_2));
782: dbms_sql.column_value (l_cursor_2, 2, v_pn_vendor_site_id);
783: dbms_sql.column_value (l_cursor_2, 3, v_pn_lia_account);
784: dbms_sql.column_value (l_cursor_2, 4, v_org_id);
785:

Line 782: dbms_sql.column_value (l_cursor_2, 2, v_pn_vendor_site_id);

778:
779: l_index_2 := l_index_2 + 1;
780:
781: dbms_sql.column_value (l_cursor_2, 1, term_ID_tbl(l_index_2));
782: dbms_sql.column_value (l_cursor_2, 2, v_pn_vendor_site_id);
783: dbms_sql.column_value (l_cursor_2, 3, v_pn_lia_account);
784: dbms_sql.column_value (l_cursor_2, 4, v_org_id);
785:
786: LE_tbl(l_index_2) := pn_r12_util_pkg.get_le_for_ap(v_pn_lia_account,v_pn_vendor_site_id,v_org_id);

Line 783: dbms_sql.column_value (l_cursor_2, 3, v_pn_lia_account);

779: l_index_2 := l_index_2 + 1;
780:
781: dbms_sql.column_value (l_cursor_2, 1, term_ID_tbl(l_index_2));
782: dbms_sql.column_value (l_cursor_2, 2, v_pn_vendor_site_id);
783: dbms_sql.column_value (l_cursor_2, 3, v_pn_lia_account);
784: dbms_sql.column_value (l_cursor_2, 4, v_org_id);
785:
786: LE_tbl(l_index_2) := pn_r12_util_pkg.get_le_for_ap(v_pn_lia_account,v_pn_vendor_site_id,v_org_id);
787:

Line 784: dbms_sql.column_value (l_cursor_2, 4, v_org_id);

780:
781: dbms_sql.column_value (l_cursor_2, 1, term_ID_tbl(l_index_2));
782: dbms_sql.column_value (l_cursor_2, 2, v_pn_vendor_site_id);
783: dbms_sql.column_value (l_cursor_2, 3, v_pn_lia_account);
784: dbms_sql.column_value (l_cursor_2, 4, v_org_id);
785:
786: LE_tbl(l_index_2) := pn_r12_util_pkg.get_le_for_ap(v_pn_lia_account,v_pn_vendor_site_id,v_org_id);
787:
788: END LOOP;

Line 790: IF dbms_sql.is_open (l_cursor_2) THEN

786: LE_tbl(l_index_2) := pn_r12_util_pkg.get_le_for_ap(v_pn_lia_account,v_pn_vendor_site_id,v_org_id);
787:
788: END LOOP;
789:
790: IF dbms_sql.is_open (l_cursor_2) THEN
791: dbms_sql.close_cursor (l_cursor_2);
792: END IF;
793:
794: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST

Line 791: dbms_sql.close_cursor (l_cursor_2);

787:
788: END LOOP;
789:
790: IF dbms_sql.is_open (l_cursor_2) THEN
791: dbms_sql.close_cursor (l_cursor_2);
792: END IF;
793:
794: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
795: UPDATE pn_payment_terms_all

Line 799: l_rows := dbms_sql.execute(l_cursor);

795: UPDATE pn_payment_terms_all
796: SET legal_entity_id = LE_tbl(i)
797: WHERE payment_term_id = term_ID_tbl(i);
798:
799: l_rows := dbms_sql.execute(l_cursor);
800:
801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);

Line 801: dbms_sql.define_column (l_cursor, 1, v_org_id);

797: WHERE payment_term_id = term_ID_tbl(i);
798:
799: l_rows := dbms_sql.execute(l_cursor);
800:
801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);

Line 802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);

798:
799: l_rows := dbms_sql.execute(l_cursor);
800:
801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);

Line 803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);

799: l_rows := dbms_sql.execute(l_cursor);
800:
801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);

Line 804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);

800:
801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);

Line 805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);

801: dbms_sql.define_column (l_cursor, 1, v_org_id);
802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);

Line 806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);

802: dbms_sql.define_column (l_cursor, 2, v_pn_payment_item_id);
803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);

Line 807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);

803: dbms_sql.define_column (l_cursor, 3, v_pn_payment_term_id);
804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);

Line 808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);

804: dbms_sql.define_column (l_cursor, 4, v_pn_export_currency_amount);
805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);

Line 809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);

805: dbms_sql.define_column (l_cursor, 5, v_pn_export_currency_code,15);
806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);

Line 810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);

806: dbms_sql.define_column (l_cursor, 6, v_pn_vendor_id);
807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);

Line 811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);

807: dbms_sql.define_column (l_cursor, 7, v_pn_vendor_site_id);
808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);

Line 812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);

808: dbms_sql.define_column (l_cursor, 8, v_pn_project_id);
809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);

Line 813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);

809: dbms_sql.define_column (l_cursor, 9, v_pn_task_id);
810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);

Line 814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);

810: dbms_sql.define_column (l_cursor, 10,v_pn_organization_id);
811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);

Line 815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);

811: dbms_sql.define_column (l_cursor, 11,v_pn_expenditure_type,30);
812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);

Line 816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);

812: dbms_sql.define_column (l_cursor, 12,v_pn_expenditure_item_date);
813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);

Line 817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);

813: dbms_sql.define_column (l_cursor, 13,v_pn_tax_group_id);
814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);

Line 818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);

814: dbms_sql.define_column (l_cursor, 14,v_pn_tax_code_id);
815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);

Line 819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);

815: dbms_sql.define_column (l_cursor, 15,v_pn_tax_classification_code,30);
816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);

Line 820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);

816: dbms_sql.define_column (l_cursor, 16,v_pn_tax_included,1);
817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);

Line 821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);

817: dbms_sql.define_column (l_cursor, 17,v_pn_distribution_set_id);
818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);

Line 822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);

818: dbms_sql.define_column (l_cursor, 18,v_pn_lease_num,30);
819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);

Line 823: dbms_sql.define_column (l_cursor, 23,v_gl_date);

819: dbms_sql.define_column (l_cursor, 19,v_pn_lease_id);
820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);

Line 824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);

820: dbms_sql.define_column (l_cursor, 20,v_pn_send_entries,1);
821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);

Line 825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);

821: dbms_sql.define_column (l_cursor, 21,v_pn_payment_schedule_id);
822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);

Line 826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);

822: dbms_sql.define_column (l_cursor, 22,v_pn_period_name,15);
823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);

Line 827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);

823: dbms_sql.define_column (l_cursor, 23,v_gl_date);
824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);

Line 828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);

824: dbms_sql.define_column (l_cursor, 24,v_pn_normalize,1);
825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);

Line 829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);

825: dbms_sql.define_column (l_cursor, 25,v_pn_due_date);
826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);

Line 830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);

826: dbms_sql.define_column (l_cursor, 26,v_pn_ap_ar_term_id);
827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);

Line 831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);

827: dbms_sql.define_column (l_cursor, 27,v_pn_accounted_date);
828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);

Line 832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);

828: dbms_sql.define_column (l_cursor, 28,v_pn_rate);
829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);

Line 833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);

829: dbms_sql.define_column (l_cursor, 29,v_pn_ap_invoice_num,50);
830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);

Line 834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);

830: dbms_sql.define_column (l_cursor, 30,v_pn_payment_purpose_code,30);
831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);
838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);

Line 835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);

831: dbms_sql.define_column (l_cursor, 31,v_pn_payment_term_type_code,30);
832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);
838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);
839:

Line 836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);

832: dbms_sql.define_column (l_cursor, 32,v_pn_lia_account);
833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);
838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);
839:
840: LOOP

Line 837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);

833: dbms_sql.define_column (l_cursor, 33,v_pn_legal_entity_id);
834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);
838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);
839:
840: LOOP
841:

Line 838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);

834: dbms_sql.define_column (l_cursor, 34,v_conv_rate);
835: dbms_sql.define_column (l_cursor, 35,v_conv_rate_type,30);
836: dbms_sql.define_column (l_cursor, 36,v_item_grouping_rule_id);
837: dbms_sql.define_column (l_cursor, 37,v_term_grouping_rule_id);
838: dbms_sql.define_column (l_cursor, 38,v_lease_grouping_rule_id);
839:
840: LOOP
841:
842: l_index := l_index + 1;

Line 844: l_count := dbms_sql.fetch_rows( l_cursor );

840: LOOP
841:
842: l_index := l_index + 1;
843:
844: l_count := dbms_sql.fetch_rows( l_cursor );
845: EXIT WHEN l_count <> 1;
846:
847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);

Line 847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);

843:
844: l_count := dbms_sql.fetch_rows( l_cursor );
845: EXIT WHEN l_count <> 1;
846:
847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);

Line 848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);

844: l_count := dbms_sql.fetch_rows( l_cursor );
845: EXIT WHEN l_count <> 1;
846:
847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);

Line 849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);

845: EXIT WHEN l_count <> 1;
846:
847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);

Line 850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);

846:
847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);

Line 851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);

847: dbms_sql.column_value (l_cursor, 1, exp_ap_cache(l_index).org_id);
848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);

Line 852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);

848: dbms_sql.column_value (l_cursor, 2, exp_ap_cache(l_index).pn_payment_item_id);
849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);

Line 853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);

849: dbms_sql.column_value (l_cursor, 3, exp_ap_cache(l_index).pn_payment_term_id);
850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);

Line 854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);

850: dbms_sql.column_value (l_cursor, 4, exp_ap_cache(l_index).pn_export_currency_amount);
851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);

Line 855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);

851: dbms_sql.column_value (l_cursor, 5, exp_ap_cache(l_index).pn_export_currency_code);
852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);

Line 856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);

852: dbms_sql.column_value (l_cursor, 6, exp_ap_cache(l_index).pn_vendor_id);
853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);

Line 857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);

853: dbms_sql.column_value (l_cursor, 7, exp_ap_cache(l_index).pn_vendor_site_id);
854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);

Line 858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);

854: dbms_sql.column_value (l_cursor, 8, exp_ap_cache(l_index).pn_project_id);
855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);

Line 859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);

855: dbms_sql.column_value (l_cursor, 9, exp_ap_cache(l_index).pn_task_id);
856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);

Line 860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);

856: dbms_sql.column_value (l_cursor, 10,exp_ap_cache(l_index).pn_organization_id);
857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);

Line 861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);

857: dbms_sql.column_value (l_cursor, 11,exp_ap_cache(l_index).pn_expenditure_type);
858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);

Line 862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);

858: dbms_sql.column_value (l_cursor, 12,exp_ap_cache(l_index).pn_expenditure_item_date);
859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);

Line 863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);

859: dbms_sql.column_value (l_cursor, 13,exp_ap_cache(l_index).pn_tax_group_id);
860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);

Line 864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);

860: dbms_sql.column_value (l_cursor, 14,exp_ap_cache(l_index).pn_tax_code_id);
861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);

Line 865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);

861: dbms_sql.column_value (l_cursor, 15,exp_ap_cache(l_index).pn_tax_classification_code);
862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);

Line 866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);

862: dbms_sql.column_value (l_cursor, 16,exp_ap_cache(l_index).pn_tax_included);
863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);

Line 867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);

863: dbms_sql.column_value (l_cursor, 17,exp_ap_cache(l_index).pn_distribution_set_id);
864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);

Line 868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);

864: dbms_sql.column_value (l_cursor, 18,exp_ap_cache(l_index).pn_lease_num);
865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);

Line 869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);

865: dbms_sql.column_value (l_cursor, 19,exp_ap_cache(l_index).pn_lease_id);
866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);

Line 870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);

866: dbms_sql.column_value (l_cursor, 20,exp_ap_cache(l_index).pn_send_entries);
867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);

Line 871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);

867: dbms_sql.column_value (l_cursor, 21,exp_ap_cache(l_index).pn_payment_schedule_id);
868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);

Line 872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);

868: dbms_sql.column_value (l_cursor, 22,exp_ap_cache(l_index).pn_period_name);
869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);

Line 873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);

869: dbms_sql.column_value (l_cursor, 23,exp_ap_cache(l_index).gl_date);
870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);

Line 874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);

870: dbms_sql.column_value (l_cursor, 24,exp_ap_cache(l_index).pn_normalize);
871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);

Line 875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);

871: dbms_sql.column_value (l_cursor, 25,exp_ap_cache(l_index).pn_due_date);
872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);

Line 876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);

872: dbms_sql.column_value (l_cursor, 26,exp_ap_cache(l_index).pn_ap_ar_term_id);
873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);

Line 877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);

873: dbms_sql.column_value (l_cursor, 27,exp_ap_cache(l_index).pn_accounted_date);
874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);

Line 878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);

874: dbms_sql.column_value (l_cursor, 28,exp_ap_cache(l_index).pn_rate);
875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);

Line 879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);

875: dbms_sql.column_value (l_cursor, 29,exp_ap_cache(l_index).pn_ap_invoice_num);
876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);

Line 880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);

876: dbms_sql.column_value (l_cursor, 30,exp_ap_cache(l_index).pn_payment_purpose_code);
877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);
884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);

Line 881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);

877: dbms_sql.column_value (l_cursor, 31,exp_ap_cache(l_index).pn_payment_term_type_code);
878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);
884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);
885:

Line 882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);

878: dbms_sql.column_value (l_cursor, 32,exp_ap_cache(l_index).pn_lia_account);
879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);
884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);
885:
886: exp_ap_cache(l_index).processed := 'N';

Line 883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);

879: dbms_sql.column_value (l_cursor, 33,exp_ap_cache(l_index).pn_legal_entity_id);
880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);
884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);
885:
886: exp_ap_cache(l_index).processed := 'N';
887:

Line 884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);

880: dbms_sql.column_value (l_cursor, 34,exp_ap_cache(l_index).conv_rate);
881: dbms_sql.column_value (l_cursor, 35,exp_ap_cache(l_index).conv_rate_type);
882: dbms_sql.column_value (l_cursor, 36,exp_ap_cache(l_index).item_grouping_rule_id);
883: dbms_sql.column_value (l_cursor, 37,exp_ap_cache(l_index).term_grouping_rule_id);
884: dbms_sql.column_value (l_cursor, 38,exp_ap_cache(l_index).lease_grouping_rule_id);
885:
886: exp_ap_cache(l_index).processed := 'N';
887:
888: -- validate the item

Line 995: IF dbms_sql.is_open (l_cursor) THEN

991: RAISE;
992: END;
993: END LOOP;
994:
995: IF dbms_sql.is_open (l_cursor) THEN
996: dbms_sql.close_cursor (l_cursor);
997: END IF;
998:
999: l_total_ctr := l_total_ctr + l_index - 1;

Line 996: dbms_sql.close_cursor (l_cursor);

992: END;
993: END LOOP;
994:
995: IF dbms_sql.is_open (l_cursor) THEN
996: dbms_sql.close_cursor (l_cursor);
997: END IF;
998:
999: l_total_ctr := l_total_ctr + l_index - 1;
1000:

Line 2093: -- dbms_sql.

2089: -- procedure.
2090: -- 18-FEB-04 Kiran Hegde o Added call to get_order_by_grpby in case of
2091: -- the grouping rule attached at SYSOP level
2092: -- 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using
2093: -- dbms_sql.
2094: -- 24-JUL-06 Hareesha o Bug# 5398654 Consider the lease-no ,sched dt,
2095: -- due dt,amt due ranges while exporting.
2096: --------------------------------------------------------------------------------
2097: PROCEDURE exp_to_ap(errbuf OUT NOCOPY VARCHAR2,