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.JAI_AR_MATCH_TAX_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,

967: WHEN OTHERS THEN
968: p_process_status := jai_constants.unexpected_error;
969: p_process_message := SUBSTR(SQLERRM,1,300);
970: END insert_trx_line_gl_dist;
971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

Line 972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,

968: p_process_status := jai_constants.unexpected_error;
969: p_process_message := SUBSTR(SQLERRM,1,300);
970: END insert_trx_line_gl_dist;
971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

Line 973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

969: p_process_message := SUBSTR(SQLERRM,1,300);
970: END insert_trx_line_gl_dist;
971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

Line 974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,

970: END insert_trx_line_gl_dist;
971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

Line 975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

971: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

Line 976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

972: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

Line 977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

973: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

Line 978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

974: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

Line 979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

975: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

Line 980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

976: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

Line 981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

977: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

Line 982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

978: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

Line 983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

979: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

Line 984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

980: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,

Line 985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

981: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,

Line 986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

982: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,

Line 987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

983: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
991: p_process_status OUT NOCOPY VARCHAR2,

Line 988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,

984: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
991: p_process_status OUT NOCOPY VARCHAR2,
992: p_process_message OUT NOCOPY VARCHAR2)

Line 989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,

985: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
991: p_process_status OUT NOCOPY VARCHAR2,
992: p_process_message OUT NOCOPY VARCHAR2)
993: IS

Line 990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,

986: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
987: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
988: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
989: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
990: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
991: p_process_status OUT NOCOPY VARCHAR2,
992: p_process_message OUT NOCOPY VARCHAR2)
993: IS
994: BEGIN

Line 998: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,

994: BEGIN
995: p_process_status := jai_constants.successful;
996: p_process_message := NULL;
997:
998: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,
999: taxable_amount,
1000: customer_trx_line_id,
1001: last_update_date,
1002: last_updated_by,

Line 1046: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

1042: END insert_trx_lines;
1043:
1044:
1045: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1046: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
1047: p_process_status OUT NOCOPY VARCHAR2,
1048: p_process_message OUT NOCOPY VARCHAR2)
1049: IS
1050: /* Ramananda for bug#5219225. */

Line 1109: FROM ra_customer_trx_lines_all

1105: WHERE customer_trx_id = p_customer_trx_id
1106: AND account_class IN ('TAX','FREIGHT')
1107: AND customer_trx_line_id IN
1108: (SELECT customer_trx_line_id
1109: FROM ra_customer_trx_lines_all
1110: WHERE customer_trx_id = p_customer_trx_id
1111: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1112: AND line_type in ('TAX','FREIGHT')
1113: )

Line 1136: FROM ra_customer_trx_lines_all

1132: WHERE customer_trx_id = p_customer_trx_id
1133: AND account_class IN ('TAX','FREIGHT')
1134: AND customer_trx_line_id IN
1135: (SELECT customer_trx_line_id
1136: FROM ra_customer_trx_lines_all
1137: WHERE customer_trx_id = p_customer_trx_id
1138: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1139: AND line_type in ('TAX','FREIGHT')
1140: );

Line 1142: --delete the data from ra_customer_trx_lines_all

1138: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1139: AND line_type in ('TAX','FREIGHT')
1140: );
1141:
1142: --delete the data from ra_customer_trx_lines_all
1143: DELETE ra_customer_trx_lines_all
1144: WHERE customer_trx_id = p_customer_trx_id
1145: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1146: AND line_type IN ('TAX','FREIGHT');

Line 1143: DELETE ra_customer_trx_lines_all

1139: AND line_type in ('TAX','FREIGHT')
1140: );
1141:
1142: --delete the data from ra_customer_trx_lines_all
1143: DELETE ra_customer_trx_lines_all
1144: WHERE customer_trx_id = p_customer_trx_id
1145: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1146: AND line_type IN ('TAX','FREIGHT');
1147:

Line 1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

1206: FROM ar_payment_schedules_all
1207: WHERE customer_trx_id = cp_customer_trx_id
1208: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1209:
1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1211: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1212: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1214: IS

Line 1212: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,

1208: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1209:
1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1211: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1212: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1214: IS
1215: SELECT NVL(SUM(extended_amount),0) extended_amount,
1216: NVL(SUM(taxable_amount),0) taxable_amount

Line 1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)

1209:
1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1211: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1212: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1214: IS
1215: SELECT NVL(SUM(extended_amount),0) extended_amount,
1216: NVL(SUM(taxable_amount),0) taxable_amount
1217: FROM ra_customer_trx_lines_all

Line 1217: FROM ra_customer_trx_lines_all

1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1214: IS
1215: SELECT NVL(SUM(extended_amount),0) extended_amount,
1216: NVL(SUM(taxable_amount),0) taxable_amount
1217: FROM ra_customer_trx_lines_all
1218: WHERE customer_trx_id = cp_customer_trx_id
1219: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
1220: AND line_type = cp_line_type;
1221:

Line 1231: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id

1227: where customer_trx_line_id = p_customer_trx_line_id
1228: and account_class = 'REC'
1229: and latest_rec_flag = 'Y';
1230:
1231: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1232: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1233: IS
1234: SELECT accounting_rule_id
1235: FROM ra_customer_trx_lines_all

Line 1232: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

1228: and account_class = 'REC'
1229: and latest_rec_flag = 'Y';
1230:
1231: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1232: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1233: IS
1234: SELECT accounting_rule_id
1235: FROM ra_customer_trx_lines_all
1236: WHERE customer_trx_line_id = cp_customer_trx_line_id;

Line 1235: FROM ra_customer_trx_lines_all

1231: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1232: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1233: IS
1234: SELECT accounting_rule_id
1235: FROM ra_customer_trx_lines_all
1236: WHERE customer_trx_line_id = cp_customer_trx_line_id;
1237:
1238: /* Ramananda for bug#5219225. */
1239: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

Line 1290: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'

1286: FROM gl_sets_of_books
1287: WHERE set_of_books_id = cp_set_of_books_id
1288: );
1289:
1290: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1291: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1292: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1293: IS
1294: SELECT interface_line_attribute6,

Line 1292: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

1288: );
1289:
1290: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1291: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1292: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1293: IS
1294: SELECT interface_line_attribute6,
1295: interface_line_attribute3,
1296: interface_line_context,

Line 1299: FROM ra_customer_trx_lines_all

1295: interface_line_attribute3,
1296: interface_line_context,
1297: NVL(extended_amount,0) extended_amount,
1298: NVL(taxable_amount,0) taxable_amount
1299: FROM ra_customer_trx_lines_all
1300: WHERE customer_trx_id = cp_customer_trx_id
1301: AND customer_trx_line_id = cp_customer_trx_line_id
1302: AND line_type = lv_line_type_line; --'LINE'
1303:

Line 1463: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;

1459: rec_customer_trx_lines cur_customer_trx_lines%ROWTYPE;
1460: rec_term_details cur_term_details%ROWTYPE;
1461: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
1462:
1463: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
1464: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1465: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1466: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
1467: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;

Line 1570: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all

1566: IF p_debug = 'Y' THEN
1567: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');
1568: END IF;
1569:
1570: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
1571: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
1572: delete_trx_data(p_customer_trx_id => p_customer_trx_id,
1573: p_process_status => lv_process_status,
1574: p_process_message => lv_process_message);

Line 1619: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id

1615:
1616: FOR rec_temp IN cur_temp_lines_insert(p_customer_trx_id)
1617: LOOP
1618:
1619: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1620: OPEN accounting_set_cur(rec_temp.link_to_cust_trx_line_id);
1621: FETCH accounting_set_cur INTO ln_accounting_rule_id;
1622: CLOSE accounting_set_cur;
1623:

Line 1647: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'

1643: END if;
1644: -- bug#7645588, end
1645:
1646:
1647: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1648: OPEN cur_customer_trx_lines(p_customer_trx_id,
1649: rec_temp.link_to_cust_trx_line_id);
1650: FETCH cur_customer_trx_lines INTO rec_customer_trx_lines;
1651: CLOSE cur_customer_trx_lines;

Line 1676: --This procedure inserts the data into ra_customer_trx_lines_all

1672: IF ld_gl_posted_date is NULL THEN
1673:
1674: -- #### IMPORTANT FOR R12 ENDS HERE
1675:
1676: --This procedure inserts the data into ra_customer_trx_lines_all
1677: insert_trx_lines(p_extended_amount => rec_temp.extended_amount,
1678: p_taxable_amount => ln_taxable_amount,
1679: p_customer_trx_line_id => rec_temp.customer_trx_line_id,
1680: p_last_update_date => rec_temp.last_update_date,

Line 1778: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

1774: END IF;
1775:
1776: END LOOP; --End rec_temp
1777:
1778: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1779: OPEN cur_total_amt_trx_lines( p_customer_trx_id,
1780: NULL,
1781: lv_line_type_line);
1782: FETCH cur_total_amt_trx_lines INTO ln_old_amount,

Line 1822: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

1818:
1819: END IF;
1820: --Added by Ramananda for bug#5495711, Ends
1821:
1822: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1823: OPEN cur_total_amt_trx_lines(p_customer_trx_id,
1824: NULL,
1825: lv_account_class_tax);
1826: FETCH cur_total_amt_trx_lines INTO ln_total_tax_amt_for_inv,

Line 1831: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

1827: ln_taxable_amount; --this variable is not being used
1828: CLOSE cur_total_amt_trx_lines;
1829:
1830:
1831: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1832: OPEN cur_total_amt_trx_lines(p_customer_trx_id,
1833: NULL,
1834: lv_account_class_freight);
1835: FETCH cur_total_amt_trx_lines INTO ln_total_frt_amt_for_inv,

Line 2402: FROM RA_CUSTOMER_TRX_LINES_ALL

2398:
2399:
2400: CURSOR MAX_LINE_CUR(p_cust_link_line_id IN NUMBER, p_line_type IN VARCHAR2) IS
2401: SELECT NVL(MAX(line_number),0)
2402: FROM RA_CUSTOMER_TRX_LINES_ALL
2403: WHERE link_to_cust_trx_line_id = p_cust_link_line_id
2404: and line_type = p_line_type;
2405:
2406:

Line 2414: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C

2410: WHERE customer_trx_id = P_CUSTOMER_TRX_ID AND LINK_TO_CUST_TRX_LINE_ID = p_link_line_id;
2411:
2412: CURSOR PREVIOUS_AMOUNT_CUR IS
2413: SELECT A.AMOUNT , A.ACCTD_AMOUNT
2414: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C
2415: WHERE A.CUSTOMER_TRX_LINE_ID = B.CUSTOMER_TRX_LINE_ID
2416: AND B.LINK_TO_CUST_TRX_LINE_ID = C.LINK_TO_CUST_TRX_LINE_ID
2417: AND C.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
2418: AND A.ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class)

Line 2437: From Ra_Customer_Trx_Lines_All

2433:
2434: /* AR Transactions with Invoicing Acctg Rules not supported by Localization, Enhancement Done on 16th NOV */
2435: Cursor accounting_set_cur IS
2436: Select accounting_rule_id
2437: From Ra_Customer_Trx_Lines_All
2438: Where Customer_Trx_Line_Id = p_link_line_id;
2439: v_accounting_rule_id Number;
2440: v_account_set_flag Char(1);
2441:

Line 2442: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is

2438: Where Customer_Trx_Line_Id = p_link_line_id;
2439: v_accounting_rule_id Number;
2440: v_account_set_flag Char(1);
2441:
2442: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
2443: Select previous_customer_trx_id
2444: from ra_customer_trx_lines_all
2445: where customer_trx_id = P_CUSTOMER_TRX_ID
2446: and line_type = p_line_type;

Line 2444: from ra_customer_trx_lines_all

2440: v_account_set_flag Char(1);
2441:
2442: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
2443: Select previous_customer_trx_id
2444: from ra_customer_trx_lines_all
2445: where customer_trx_id = P_CUSTOMER_TRX_ID
2446: and line_type = p_line_type;
2447: --AND customer_trx_line_id = p_link_line_id; --Added this condition on 05-Apr-2002 as it should fetch only one value
2448: v_prev_customer_trx_id Number;

Line 2460: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is

2456: v_interface_line_attribute6 Varchar2(30);
2457: v_return_reference_type_code Varchar2(30);
2458: v_credit_invoice_line_id Number;
2459:
2460: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
2461: Select interface_line_attribute6
2462: From ra_customer_trx_lines_all
2463: Where customer_trx_id = p_customer_trx_id
2464: and line_type = p_line_type;

Line 2462: From ra_customer_trx_lines_all

2458: v_credit_invoice_line_id Number;
2459:
2460: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
2461: Select interface_line_attribute6
2462: From ra_customer_trx_lines_all
2463: Where customer_trx_id = p_customer_trx_id
2464: and line_type = p_line_type;
2465:
2466: Cursor Ref_type_cur(p_line_id IN Number) is

Line 2518: Cursor get_ext_amt_ln( p_line_type ra_customer_trx_lines.line_type%TYPE )

2514: -- start of modification added by subbu and Jagdish on 10-jun-01 for discount issue.
2515: v_extended_amount_line number;
2516: v_taxable_amt number := 0;
2517:
2518: Cursor get_ext_amt_ln( p_line_type ra_customer_trx_lines.line_type%TYPE )
2519: is Select extended_amount
2520: from Ra_customer_trx_lines_all
2521: where customer_trx_id = P_CUSTOMER_TRX_ID
2522: and customer_trx_line_id = P_LINK_LINE_ID

Line 2520: from Ra_customer_trx_lines_all

2516: v_taxable_amt number := 0;
2517:
2518: Cursor get_ext_amt_ln( p_line_type ra_customer_trx_lines.line_type%TYPE )
2519: is Select extended_amount
2520: from Ra_customer_trx_lines_all
2521: where customer_trx_id = P_CUSTOMER_TRX_ID
2522: and customer_trx_line_id = P_LINK_LINE_ID
2523: and line_type = p_line_type;--rchandan for bug#4428980
2524:

Line 2526: from Ra_customer_trx_lines_all

2522: and customer_trx_line_id = P_LINK_LINE_ID
2523: and line_type = p_line_type;--rchandan for bug#4428980
2524:
2525: Cursor get_ext_amt_tax is Select extended_amount,customer_trx_line_id
2526: from Ra_customer_trx_lines_all
2527: where customer_trx_id = P_CUSTOMER_TRX_ID
2528: and Link_to_cust_trx_line_id = P_LINK_LINE_ID
2529: and line_type = lv_tax_const;--rchandan for bug#4428980
2530:

Line 2534: from ra_customer_trx_lines_all

2530:
2531: get_ext_amt_tax_rec get_ext_amt_tax%rowtype;
2532:
2533: Cursor get_taxable_amt(cust_trx_ln_id number) Is Select nvl(taxable_amount,0)
2534: from ra_customer_trx_lines_all
2535: where customer_trx_line_id = cust_trx_ln_id
2536: and customer_trx_id = P_CUSTOMER_TRX_ID
2537: and line_type = lv_tax_const;--rchandan for bug#4428980
2538:

Line 2588: tables ra_customer_trx_lines_all ,ra_cust_trx_line_gl_dist_all.

2584: 3 2002/03/22 RPK : for BUG#2285636
2585:
2586: Code modified to rollback the entire transactions if a transaction
2587: is failed.That is, the tax lines will be inserted all or none in the
2588: tables ra_customer_trx_lines_all ,ra_cust_trx_line_gl_dist_all.
2589: Also,whenever any record got errored out,then the corresponding invoice
2590: taxes will not be processed to the base table itself and that record will
2591: be updated to 'R'(column error_flag).
2592:

Line 2736: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table

2732: v_sql_num :=13;
2733:
2734:
2735: -- the following select statement commented and using the next one instead
2736: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table
2737: -- with the link_to_cust_trx_line_id column instead of based on the customer_trx_line_id
2738: -- column in the ra_cust_trx_line_gl_dist_all table. -- bug # 2784431
2739:
2740: /*

Line 2747: FROM ra_customer_trx_lines_all

2743: AND Account_class IN ('TAX','FREIGHT'); --Added on 09-Apr-2002 For the BUG#2303830
2744: */
2745:
2746: SELECT COUNT(Customer_trx_line_id) INTO v_rec_ctr
2747: FROM ra_customer_trx_lines_all
2748: where link_to_cust_trx_line_id = p_link_line_id
2749: and line_type in (lv_tax_const,lv_freight_acc_class); --rchandan for bug#4428980
2750:
2751:

Line 2758: FROM RA_CUSTOMER_TRX_LINES_ALL

2754: v_sql_num :=14;
2755:
2756: DELETE RA_CUST_TRX_LINE_GL_DIST_ALL
2757: WHERE CUSTOMER_TRX_LINE_ID IN (SELECT CUSTOMER_TRX_LINE_ID
2758: FROM RA_CUSTOMER_TRX_LINES_ALL
2759: WHERE LINK_TO_CUST_TRX_LINE_ID = LINK_REC.LINK_TO_CUST_TRX_LINE_ID)
2760: AND ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class); --rchandan for bug#4428980
2761:
2762: -- added for mrc -- sriram - 26/12 -- 3326394

Line 2773: FROM RA_CUSTOMER_TRX_LINES_ALL

2769: AND ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
2770: AND CUSTOMER_TRX_LINE_ID
2771: IN
2772: (SELECT CUSTOMER_TRX_LINE_ID
2773: FROM RA_CUSTOMER_TRX_LINES_ALL
2774: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
2775: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID
2776: AND LINE_TYPE IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
2777: )

Line 2801: FROM RA_CUSTOMER_TRX_LINES_ALL

2797: AND ACCOUNT_CLASS IN ('TAX','FREIGHT')
2798: AND CUSTOMER_TRX_LINE_ID
2799: IN
2800: (SELECT CUSTOMER_TRX_LINE_ID
2801: FROM RA_CUSTOMER_TRX_LINES_ALL
2802: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
2803: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID
2804: AND LINE_TYPE IN ('TAX','FREIGHT')
2805: )

Line 2813: DELETE RA_CUSTOMER_TRX_LINES_ALL

2809: */
2810:
2811: v_sql_num :=15;
2812:
2813: DELETE RA_CUSTOMER_TRX_LINES_ALL
2814: WHERE LINK_TO_CUST_TRX_LINE_ID = LINK_REC.LINK_TO_CUST_TRX_LINE_ID;
2815: v_sql_num :=16;
2816:
2817: Update Ar_Payment_Schedules_All

Line 2913: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,

2909: CLOSE c_gl_posted_date_cur ;
2910:
2911: IF ld_gl_posted_date is NULL THEN
2912:
2913: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,
2914: customer_trx_line_id,
2915: last_update_date,
2916: last_updated_by,
2917: creation_date,

Line 3017: UPDATE RA_CUSTOMER_TRX_LINES_ALL

3013: END IF ; --v_gl_posted_date is null
3014: /* Modified by Ramananda for bug#4468353 due to sla uptake by AR, end */
3015:
3016: ELSE
3017: UPDATE RA_CUSTOMER_TRX_LINES_ALL
3018: SET EXTENDED_AMOUNT = TEMP_REC.EXTENDED_AMOUNT,
3019: LAST_UPDATE_DATE = TEMP_REC.LAST_UPDATE_DATE,
3020: LAST_UPDATED_BY = TEMP_REC.LAST_UPDATED_BY,
3021: CREATION_DATE = TEMP_REC.CREATION_DATE,

Line 3266: UPDATE ra_customer_trx_lines_all

3262: EXIT WHEN get_ext_amt_tax%NOTFOUND;
3263: OPEN get_taxable_amt(get_ext_amt_tax_rec.customer_trx_line_id);
3264: FETCH get_taxable_amt INTO v_taxable_amt;
3265: IF v_taxable_amt = 0 THEN
3266: UPDATE ra_customer_trx_lines_all
3267: SET Taxable_amount = (v_extended_amount_line - get_ext_amt_tax_rec.extended_amount)
3268: WHERE Customer_trx_line_id = get_ext_amt_tax_rec.customer_trx_line_id
3269: and customer_trx_id = P_CUSTOMER_TRX_ID
3270: and link_to_cust_trx_line_id = P_LINK_LINE_ID