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

Line 799: | dbms_sql.bind_variable |

795: | |
796: | SCOPE - PRIVATE |
797: | |
798: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
799: | dbms_sql.bind_variable |
800: | arp_util.debug |
801: | |
802: | ARGUMENTS : IN: |
803: | p_update_cursor - ID of the update cursor |

Line 840: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

836: /*------------------+
837: | Dummy constants |
838: +------------------*/
839:
840: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
841: AR_TEXT_DUMMY);
842:
843: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
844: AR_FLAG_DUMMY);

Line 843: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

839:
840: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
841: AR_TEXT_DUMMY);
842:
843: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
844: AR_FLAG_DUMMY);
845:
846: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
847: AR_NUMBER_DUMMY);

Line 846: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

842:
843: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
844: AR_FLAG_DUMMY);
845:
846: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
847: AR_NUMBER_DUMMY);
848:
849: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
850: AR_DATE_DUMMY);

Line 849: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

845:
846: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
847: AR_NUMBER_DUMMY);
848:
849: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
850: AR_DATE_DUMMY);
851:
852: /*------------------+
853: | WHO variables |

Line 856: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

852: /*------------------+
853: | WHO variables |
854: +------------------*/
855:
856: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
857: pg_user_id);
858:
859: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
860: pg_login_id);

Line 859: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

855:
856: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
857: pg_user_id);
858:
859: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
860: pg_login_id);
861:
862: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
863: pg_conc_login_id);

Line 862: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

858:
859: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
860: pg_login_id);
861:
862: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
863: pg_conc_login_id);
864:
865: /*----------------------------------------+
866: | Rounding and exchange rate variables |

Line 869: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

865: /*----------------------------------------+
866: | Rounding and exchange rate variables |
867: +----------------------------------------*/
868:
869: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
870: p_exchange_rate);
871:
872: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
873: p_currency_code);

Line 872: dbms_sql.bind_variable(p_update_cursor, ':currency_code',

868:
869: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
870: p_exchange_rate);
871:
872: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
873: p_currency_code);
874:
875: dbms_sql.bind_variable(p_update_cursor, ':precision',
876: p_precision);

Line 875: dbms_sql.bind_variable(p_update_cursor, ':precision',

871:
872: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
873: p_currency_code);
874:
875: dbms_sql.bind_variable(p_update_cursor, ':precision',
876: p_precision);
877:
878: dbms_sql.bind_variable(p_update_cursor, ':mau',
879: p_mau);

Line 878: dbms_sql.bind_variable(p_update_cursor, ':mau',

874:
875: dbms_sql.bind_variable(p_update_cursor, ':precision',
876: p_precision);
877:
878: dbms_sql.bind_variable(p_update_cursor, ':mau',
879: p_mau);
880:
881: /*----------------------------------------------+
882: | Bind variables for all columns in the table |

Line 885: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',

881: /*----------------------------------------------+
882: | Bind variables for all columns in the table |
883: +----------------------------------------------*/
884:
885: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
886: p_dist_rec.cust_trx_line_salesrep_id);
887:
888: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_gl_dist_id',
889: p_dist_rec.cust_trx_line_gl_dist_id);

Line 888: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_gl_dist_id',

884:
885: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
886: p_dist_rec.cust_trx_line_salesrep_id);
887:
888: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_gl_dist_id',
889: p_dist_rec.cust_trx_line_gl_dist_id);
890:
891: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
892: p_dist_rec.customer_trx_id);

Line 891: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

887:
888: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_gl_dist_id',
889: p_dist_rec.cust_trx_line_gl_dist_id);
890:
891: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
892: p_dist_rec.customer_trx_id);
893:
894: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
895: p_dist_rec.customer_trx_line_id);

Line 894: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',

890:
891: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
892: p_dist_rec.customer_trx_id);
893:
894: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
895: p_dist_rec.customer_trx_line_id);
896:
897: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
898: p_dist_rec.cust_trx_line_salesrep_id);

Line 897: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',

893:
894: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
895: p_dist_rec.customer_trx_line_id);
896:
897: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
898: p_dist_rec.cust_trx_line_salesrep_id);
899:
900: dbms_sql.bind_variable(p_update_cursor, ':account_class',
901: p_dist_rec.account_class);

Line 900: dbms_sql.bind_variable(p_update_cursor, ':account_class',

896:
897: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
898: p_dist_rec.cust_trx_line_salesrep_id);
899:
900: dbms_sql.bind_variable(p_update_cursor, ':account_class',
901: p_dist_rec.account_class);
902:
903: dbms_sql.bind_variable(p_update_cursor, ':percent',
904: p_dist_rec.percent);

Line 903: dbms_sql.bind_variable(p_update_cursor, ':percent',

899:
900: dbms_sql.bind_variable(p_update_cursor, ':account_class',
901: p_dist_rec.account_class);
902:
903: dbms_sql.bind_variable(p_update_cursor, ':percent',
904: p_dist_rec.percent);
905:
906: dbms_sql.bind_variable(p_update_cursor, ':amount',
907: p_dist_rec.amount);

Line 906: dbms_sql.bind_variable(p_update_cursor, ':amount',

902:
903: dbms_sql.bind_variable(p_update_cursor, ':percent',
904: p_dist_rec.percent);
905:
906: dbms_sql.bind_variable(p_update_cursor, ':amount',
907: p_dist_rec.amount);
908:
909: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',
910: p_dist_rec.acctd_amount);

Line 909: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',

905:
906: dbms_sql.bind_variable(p_update_cursor, ':amount',
907: p_dist_rec.amount);
908:
909: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',
910: p_dist_rec.acctd_amount);
911:
912: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
913: p_dist_rec.gl_date);

Line 912: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

908:
909: dbms_sql.bind_variable(p_update_cursor, ':acctd_amount',
910: p_dist_rec.acctd_amount);
911:
912: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
913: p_dist_rec.gl_date);
914:
915: dbms_sql.bind_variable(p_update_cursor, ':original_gl_date',
916: p_dist_rec.original_gl_date);

Line 915: dbms_sql.bind_variable(p_update_cursor, ':original_gl_date',

911:
912: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
913: p_dist_rec.gl_date);
914:
915: dbms_sql.bind_variable(p_update_cursor, ':original_gl_date',
916: p_dist_rec.original_gl_date);
917:
918: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
919: p_dist_rec.gl_posted_date);

Line 918: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',

914:
915: dbms_sql.bind_variable(p_update_cursor, ':original_gl_date',
916: p_dist_rec.original_gl_date);
917:
918: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
919: p_dist_rec.gl_posted_date);
920:
921: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
922: p_dist_rec.code_combination_id);

Line 921: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',

917:
918: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
919: p_dist_rec.gl_posted_date);
920:
921: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
922: p_dist_rec.code_combination_id);
923:
924: dbms_sql.bind_variable(p_update_cursor, ':concatenated_segments',
925: p_dist_rec.concatenated_segments);

Line 924: dbms_sql.bind_variable(p_update_cursor, ':concatenated_segments',

920:
921: dbms_sql.bind_variable(p_update_cursor, ':code_combination_id',
922: p_dist_rec.code_combination_id);
923:
924: dbms_sql.bind_variable(p_update_cursor, ':concatenated_segments',
925: p_dist_rec.concatenated_segments);
926:
927: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_ccid',
928: p_dist_rec.collected_tax_ccid);

Line 927: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_ccid',

923:
924: dbms_sql.bind_variable(p_update_cursor, ':concatenated_segments',
925: p_dist_rec.concatenated_segments);
926:
927: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_ccid',
928: p_dist_rec.collected_tax_ccid);
929:
930: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_concat_seg',
931: p_dist_rec.collected_tax_concat_seg);

Line 930: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_concat_seg',

926:
927: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_ccid',
928: p_dist_rec.collected_tax_ccid);
929:
930: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_concat_seg',
931: p_dist_rec.collected_tax_concat_seg);
932:
933: dbms_sql.bind_variable(p_update_cursor, ':comments',
934: p_dist_rec.comments);

Line 933: dbms_sql.bind_variable(p_update_cursor, ':comments',

929:
930: dbms_sql.bind_variable(p_update_cursor, ':collected_tax_concat_seg',
931: p_dist_rec.collected_tax_concat_seg);
932:
933: dbms_sql.bind_variable(p_update_cursor, ':comments',
934: p_dist_rec.comments);
935:
936: dbms_sql.bind_variable(p_update_cursor, ':account_set_flag',
937: p_dist_rec.account_set_flag);

Line 936: dbms_sql.bind_variable(p_update_cursor, ':account_set_flag',

932:
933: dbms_sql.bind_variable(p_update_cursor, ':comments',
934: p_dist_rec.comments);
935:
936: dbms_sql.bind_variable(p_update_cursor, ':account_set_flag',
937: p_dist_rec.account_set_flag);
938:
939: dbms_sql.bind_variable(p_update_cursor, ':latest_rec_flag',
940: p_dist_rec.latest_rec_flag);

Line 939: dbms_sql.bind_variable(p_update_cursor, ':latest_rec_flag',

935:
936: dbms_sql.bind_variable(p_update_cursor, ':account_set_flag',
937: p_dist_rec.account_set_flag);
938:
939: dbms_sql.bind_variable(p_update_cursor, ':latest_rec_flag',
940: p_dist_rec.latest_rec_flag);
941:
942: /* bug 3598021 - 3630436 */
943: dbms_sql.bind_variable(p_update_cursor, ':rec_offset_flag',

Line 943: dbms_sql.bind_variable(p_update_cursor, ':rec_offset_flag',

939: dbms_sql.bind_variable(p_update_cursor, ':latest_rec_flag',
940: p_dist_rec.latest_rec_flag);
941:
942: /* bug 3598021 - 3630436 */
943: dbms_sql.bind_variable(p_update_cursor, ':rec_offset_flag',
944: p_dist_rec.rec_offset_flag);
945:
946: dbms_sql.bind_variable(p_update_cursor, ':rounding_correction_flag',
947: p_dist_rec.rounding_correction_flag);

Line 946: dbms_sql.bind_variable(p_update_cursor, ':rounding_correction_flag',

942: /* bug 3598021 - 3630436 */
943: dbms_sql.bind_variable(p_update_cursor, ':rec_offset_flag',
944: p_dist_rec.rec_offset_flag);
945:
946: dbms_sql.bind_variable(p_update_cursor, ':rounding_correction_flag',
947: p_dist_rec.rounding_correction_flag);
948:
949: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
950: p_dist_rec.ussgl_transaction_code);

Line 949: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',

945:
946: dbms_sql.bind_variable(p_update_cursor, ':rounding_correction_flag',
947: p_dist_rec.rounding_correction_flag);
948:
949: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
950: p_dist_rec.ussgl_transaction_code);
951:
952: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
953: p_dist_rec.ussgl_transaction_code_context);

Line 952: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',

948:
949: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
950: p_dist_rec.ussgl_transaction_code);
951:
952: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
953: p_dist_rec.ussgl_transaction_code_context);
954:
955: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
956: p_dist_rec.attribute_category);

Line 955: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

951:
952: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
953: p_dist_rec.ussgl_transaction_code_context);
954:
955: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
956: p_dist_rec.attribute_category);
957:
958: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
959: p_dist_rec.attribute1);

Line 958: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

954:
955: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
956: p_dist_rec.attribute_category);
957:
958: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
959: p_dist_rec.attribute1);
960:
961: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
962: p_dist_rec.attribute2);

Line 961: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

957:
958: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
959: p_dist_rec.attribute1);
960:
961: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
962: p_dist_rec.attribute2);
963:
964: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
965: p_dist_rec.attribute3);

Line 964: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

960:
961: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
962: p_dist_rec.attribute2);
963:
964: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
965: p_dist_rec.attribute3);
966:
967: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
968: p_dist_rec.attribute4);

Line 967: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

963:
964: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
965: p_dist_rec.attribute3);
966:
967: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
968: p_dist_rec.attribute4);
969:
970: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
971: p_dist_rec.attribute5);

Line 970: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

966:
967: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
968: p_dist_rec.attribute4);
969:
970: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
971: p_dist_rec.attribute5);
972:
973: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
974: p_dist_rec.attribute6);

Line 973: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

969:
970: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
971: p_dist_rec.attribute5);
972:
973: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
974: p_dist_rec.attribute6);
975:
976: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
977: p_dist_rec.attribute7);

Line 976: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

972:
973: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
974: p_dist_rec.attribute6);
975:
976: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
977: p_dist_rec.attribute7);
978:
979: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
980: p_dist_rec.attribute8);

Line 979: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

975:
976: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
977: p_dist_rec.attribute7);
978:
979: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
980: p_dist_rec.attribute8);
981:
982: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
983: p_dist_rec.attribute9);

Line 982: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

978:
979: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
980: p_dist_rec.attribute8);
981:
982: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
983: p_dist_rec.attribute9);
984:
985: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
986: p_dist_rec.attribute10);

Line 985: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

981:
982: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
983: p_dist_rec.attribute9);
984:
985: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
986: p_dist_rec.attribute10);
987:
988: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
989: p_dist_rec.attribute11);

Line 988: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

984:
985: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
986: p_dist_rec.attribute10);
987:
988: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
989: p_dist_rec.attribute11);
990:
991: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
992: p_dist_rec.attribute12);

Line 991: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

987:
988: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
989: p_dist_rec.attribute11);
990:
991: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
992: p_dist_rec.attribute12);
993:
994: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
995: p_dist_rec.attribute13);

Line 994: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

990:
991: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
992: p_dist_rec.attribute12);
993:
994: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
995: p_dist_rec.attribute13);
996:
997: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
998: p_dist_rec.attribute14);

Line 997: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

993:
994: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
995: p_dist_rec.attribute13);
996:
997: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
998: p_dist_rec.attribute14);
999:
1000: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
1001: p_dist_rec.attribute15);

Line 1000: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

996:
997: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
998: p_dist_rec.attribute14);
999:
1000: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
1001: p_dist_rec.attribute15);
1002:
1003: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
1004: p_dist_rec.set_of_books_id);

Line 1003: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

999:
1000: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
1001: p_dist_rec.attribute15);
1002:
1003: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
1004: p_dist_rec.set_of_books_id);
1005:
1006: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
1007: p_dist_rec.posting_control_id);

Line 1006: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',

1002:
1003: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
1004: p_dist_rec.set_of_books_id);
1005:
1006: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
1007: p_dist_rec.posting_control_id);
1008:
1009: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
1010: p_dist_rec.last_update_date);

Line 1009: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

1005:
1006: dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
1007: p_dist_rec.posting_control_id);
1008:
1009: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
1010: p_dist_rec.last_update_date);
1011:
1012: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
1013: p_dist_rec.last_updated_by);

Line 1012: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

1008:
1009: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
1010: p_dist_rec.last_update_date);
1011:
1012: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
1013: p_dist_rec.last_updated_by);
1014:
1015: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
1016: p_dist_rec.creation_date);

Line 1015: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

1011:
1012: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
1013: p_dist_rec.last_updated_by);
1014:
1015: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
1016: p_dist_rec.creation_date);
1017:
1018: dbms_sql.bind_variable(p_update_cursor, ':created_by',
1019: p_dist_rec.created_by);

Line 1018: dbms_sql.bind_variable(p_update_cursor, ':created_by',

1014:
1015: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
1016: p_dist_rec.creation_date);
1017:
1018: dbms_sql.bind_variable(p_update_cursor, ':created_by',
1019: p_dist_rec.created_by);
1020:
1021: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
1022: p_dist_rec.last_update_login);

Line 1021: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

1017:
1018: dbms_sql.bind_variable(p_update_cursor, ':created_by',
1019: p_dist_rec.created_by);
1020:
1021: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
1022: p_dist_rec.last_update_login);
1023:
1024: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
1025: p_dist_rec.program_application_id);

Line 1024: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

1020:
1021: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
1022: p_dist_rec.last_update_login);
1023:
1024: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
1025: p_dist_rec.program_application_id);
1026:
1027: dbms_sql.bind_variable(p_update_cursor, ':program_id',
1028: p_dist_rec.program_id);

Line 1027: dbms_sql.bind_variable(p_update_cursor, ':program_id',

1023:
1024: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
1025: p_dist_rec.program_application_id);
1026:
1027: dbms_sql.bind_variable(p_update_cursor, ':program_id',
1028: p_dist_rec.program_id);
1029:
1030: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
1031: p_dist_rec.program_update_date);

Line 1030: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

1026:
1027: dbms_sql.bind_variable(p_update_cursor, ':program_id',
1028: p_dist_rec.program_id);
1029:
1030: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
1031: p_dist_rec.program_update_date);
1032:
1033:
1034: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');

Line 1348: | dbms_sql.open_cursor |

1344: | SCOPE - PRIVATE |
1345: | |
1346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1347: | arp_util.debug |
1348: | dbms_sql.open_cursor |
1349: | dbms_sql.parse |
1350: | dbms_sql.execute |
1351: | dbms_sql.close_cursor |
1352: | |

Line 1349: | dbms_sql.parse |

1345: | |
1346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1347: | arp_util.debug |
1348: | dbms_sql.open_cursor |
1349: | dbms_sql.parse |
1350: | dbms_sql.execute |
1351: | dbms_sql.close_cursor |
1352: | |
1353: | ARGUMENTS : IN: |

Line 1350: | dbms_sql.execute |

1346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1347: | arp_util.debug |
1348: | dbms_sql.open_cursor |
1349: | dbms_sql.parse |
1350: | dbms_sql.execute |
1351: | dbms_sql.close_cursor |
1352: | |
1353: | ARGUMENTS : IN: |
1354: | p_update_cursor - identifies the cursor to use |

Line 1351: | dbms_sql.close_cursor |

1347: | arp_util.debug |
1348: | dbms_sql.open_cursor |
1349: | dbms_sql.parse |
1350: | dbms_sql.execute |
1351: | dbms_sql.close_cursor |
1352: | |
1353: | ARGUMENTS : IN: |
1354: | p_update_cursor - identifies the cursor to use |
1355: | p_where_clause - identifies which rows to update |

Line 1393: gl_dist_array dbms_sql.number_table; /* mrc */

1389: IS
1390:
1391: l_count number;
1392: l_update_statement varchar2(25000);
1393: gl_dist_array dbms_sql.number_table; /* mrc */
1394:
1395: BEGIN
1396: arp_util.debug('arp_ctlgd_pkg.generic_update()+');
1397:

Line 1407: p_update_cursor := dbms_sql.open_cursor;

1403: +--------------------------------------------------------------*/
1404:
1405: IF (p_update_cursor IS NULL)
1406: THEN
1407: p_update_cursor := dbms_sql.open_cursor;
1408:
1409: /*---------------------------------+
1410: | Construct the update statement |
1411: +---------------------------------*/

Line 1428: dbms_sql.parse(p_update_cursor,

1424: /*-----------------------------------------------+
1425: | Parse, bind, execute and close the statement |
1426: +-----------------------------------------------*/
1427:
1428: dbms_sql.parse(p_update_cursor,
1429: l_update_statement,
1430: dbms_sql.v7);
1431:
1432: END IF;

Line 1430: dbms_sql.v7);

1426: +-----------------------------------------------*/
1427:
1428: dbms_sql.parse(p_update_cursor,
1429: l_update_statement,
1430: dbms_sql.v7);
1431:
1432: END IF;
1433:
1434: arp_ctlgd_pkg.bind_dist_variables(p_update_cursor,

Line 1445: dbms_sql.bind_variable(p_update_cursor, ':where_1',

1441: /*-----------------------------------------+
1442: | Bind the variables in the where clause |
1443: +-----------------------------------------*/
1444:
1445: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1446: p_where1);
1447:
1448: dbms_sql.bind_variable(p_update_cursor, ':where_account_set_flag',
1449: p_account_set_flag);

Line 1448: dbms_sql.bind_variable(p_update_cursor, ':where_account_set_flag',

1444:
1445: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1446: p_where1);
1447:
1448: dbms_sql.bind_variable(p_update_cursor, ':where_account_set_flag',
1449: p_account_set_flag);
1450:
1451: dbms_sql.bind_variable(p_update_cursor, ':where_account_class',
1452: p_account_class);

Line 1451: dbms_sql.bind_variable(p_update_cursor, ':where_account_class',

1447:
1448: dbms_sql.bind_variable(p_update_cursor, ':where_account_set_flag',
1449: p_account_set_flag);
1450:
1451: dbms_sql.bind_variable(p_update_cursor, ':where_account_class',
1452: p_account_class);
1453:
1454: /*-----------------------+
1455: | bind output variable |

Line 1457: dbms_sql.bind_array(p_update_cursor,':gl_dist_key_value',

1453:
1454: /*-----------------------+
1455: | bind output variable |
1456: +-----------------------*/
1457: dbms_sql.bind_array(p_update_cursor,':gl_dist_key_value',
1458: gl_dist_array);
1459:
1460: l_count := dbms_sql.execute(p_update_cursor);
1461:

Line 1460: l_count := dbms_sql.execute(p_update_cursor);

1456: +-----------------------*/
1457: dbms_sql.bind_array(p_update_cursor,':gl_dist_key_value',
1458: gl_dist_array);
1459:
1460: l_count := dbms_sql.execute(p_update_cursor);
1461:
1462: arp_util.debug( to_char(l_count) || ' rows updated');
1463:
1464: /*------------------------------------------+

Line 1468: dbms_sql.variable_value( p_update_cursor, ':gl_dist_key_value',

1464: /*------------------------------------------+
1465: | get RETURNING COLUMN into OUT NOCOPY bind array |
1466: +------------------------------------------*/
1467:
1468: dbms_sql.variable_value( p_update_cursor, ':gl_dist_key_value',
1469: gl_dist_array);
1470:
1471: /*------------------------------------------------------------+
1472: | Raise the NO_DATA_FOUND exception if no rows were updated |

Line 1503: to_char(dbms_sql.last_error_position));

1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1501: arp_util.debug(l_update_statement);
1502: arp_util.debug('Error at character: ' ||
1503: to_char(dbms_sql.last_error_position));
1504: RAISE;
1505: END;
1506:
1507: /*===========================================================================+