968: l_csldtion_inv_line.tax_amount := l_csldted_inv_line.tax_amount;
969: l_csldtion_inv_line.discount_flag := l_csldted_inv_line.discount_flag;
970: l_csldtion_inv_line.enabled_flag := l_csldted_inv_line.enabled_flag;
971: l_csldtion_inv_line.last_update_date :=SYSDATE;
972: --l_csldtion_inv_line.last_updated_by := fnd_global.LOGIN_ID();--Qiong fix bug 10638369
973: l_csldtion_inv_line.last_updated_by := fnd_global.USER_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
969: l_csldtion_inv_line.discount_flag := l_csldted_inv_line.discount_flag;
970: l_csldtion_inv_line.enabled_flag := l_csldted_inv_line.enabled_flag;
971: l_csldtion_inv_line.last_update_date :=SYSDATE;
972: --l_csldtion_inv_line.last_updated_by := fnd_global.LOGIN_ID();--Qiong fix bug 10638369
973: l_csldtion_inv_line.last_updated_by := fnd_global.USER_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
971: l_csldtion_inv_line.last_update_date :=SYSDATE;
972: --l_csldtion_inv_line.last_updated_by := fnd_global.LOGIN_ID();--Qiong fix bug 10638369
973: l_csldtion_inv_line.last_updated_by := fnd_global.USER_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
972: --l_csldtion_inv_line.last_updated_by := fnd_global.LOGIN_ID();--Qiong fix bug 10638369
973: l_csldtion_inv_line.last_updated_by := fnd_global.USER_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
980: l_csldtion_inv_line.PROGRAM_UPDATE_DATE :=SYSDATE;
973: l_csldtion_inv_line.last_updated_by := fnd_global.USER_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
980: l_csldtion_inv_line.PROGRAM_UPDATE_DATE :=SYSDATE;
981: l_csldtion_inv_line.request_id := fnd_global.CONC_REQUEST_ID();
974: l_csldtion_inv_line.creation_date :=SYSDATE;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
980: l_csldtion_inv_line.PROGRAM_UPDATE_DATE :=SYSDATE;
981: l_csldtion_inv_line.request_id := fnd_global.CONC_REQUEST_ID();
982: l_csldtion_inv_line.discount_tax_amount :=l_csldted_inv_line.discount_tax_amount;
975: --l_csldtion_inv_line.created_by := fnd_global.LOGIN_ID();
976: l_csldtion_inv_line.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
980: l_csldtion_inv_line.PROGRAM_UPDATE_DATE :=SYSDATE;
981: l_csldtion_inv_line.request_id := fnd_global.CONC_REQUEST_ID();
982: l_csldtion_inv_line.discount_tax_amount :=l_csldted_inv_line.discount_tax_amount;
983: l_csldtion_inv_line.discount_amount :=l_csldted_inv_line.discount_amount;
977: l_csldtion_inv_line.last_update_login := fnd_global.LOGIN_ID();
978: l_csldtion_inv_line.program_id := fnd_global.CONC_PROGRAM_ID;
979: l_csldtion_inv_line.PROGRAM_APPLICATON_ID := fnd_global.PROG_APPL_ID();
980: l_csldtion_inv_line.PROGRAM_UPDATE_DATE :=SYSDATE;
981: l_csldtion_inv_line.request_id := fnd_global.CONC_REQUEST_ID();
982: l_csldtion_inv_line.discount_tax_amount :=l_csldted_inv_line.discount_tax_amount;
983: l_csldtion_inv_line.discount_amount :=l_csldted_inv_line.discount_amount;
984: l_csldtion_inv_line.discount_rate :=l_csldted_inv_line.discount_rate;
985: l_csldtion_inv.trx_lines.EXTEND;
1331: l_csldtion_inv.trx_header.cancel_flag :='N';
1332: l_csldtion_inv.trx_header.legal_entity_id :=l_csldted_inv.trx_header.legal_entity_id;
1333: l_csldtion_inv.trx_header.fp_tax_registration_number :=l_fp_tax_registration_number;
1334: l_csldtion_inv.trx_header.tp_tax_registration_number :=l_tp_tax_registration_number;
1335: l_csldtion_inv.trx_header.request_id := fnd_global.CONC_REQUEST_ID();
1336: l_csldtion_inv.trx_header.program_application_id := fnd_global.PROG_APPL_ID();
1337: l_csldtion_inv.trx_header.program_id := fnd_global.CONC_PROGRAM_ID;
1338: l_csldtion_inv.trx_header.program_update_date := SYSDATE;
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1332: l_csldtion_inv.trx_header.legal_entity_id :=l_csldted_inv.trx_header.legal_entity_id;
1333: l_csldtion_inv.trx_header.fp_tax_registration_number :=l_fp_tax_registration_number;
1334: l_csldtion_inv.trx_header.tp_tax_registration_number :=l_tp_tax_registration_number;
1335: l_csldtion_inv.trx_header.request_id := fnd_global.CONC_REQUEST_ID();
1336: l_csldtion_inv.trx_header.program_application_id := fnd_global.PROG_APPL_ID();
1337: l_csldtion_inv.trx_header.program_id := fnd_global.CONC_PROGRAM_ID;
1338: l_csldtion_inv.trx_header.program_update_date := SYSDATE;
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1333: l_csldtion_inv.trx_header.fp_tax_registration_number :=l_fp_tax_registration_number;
1334: l_csldtion_inv.trx_header.tp_tax_registration_number :=l_tp_tax_registration_number;
1335: l_csldtion_inv.trx_header.request_id := fnd_global.CONC_REQUEST_ID();
1336: l_csldtion_inv.trx_header.program_application_id := fnd_global.PROG_APPL_ID();
1337: l_csldtion_inv.trx_header.program_id := fnd_global.CONC_PROGRAM_ID;
1338: l_csldtion_inv.trx_header.program_update_date := SYSDATE;
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1336: l_csldtion_inv.trx_header.program_application_id := fnd_global.PROG_APPL_ID();
1337: l_csldtion_inv.trx_header.program_id := fnd_global.CONC_PROGRAM_ID;
1338: l_csldtion_inv.trx_header.program_update_date := SYSDATE;
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1342: l_csldtion_inv.trx_header.last_update_date := SYSDATE;
1343: -- l_csldtion_inv.trx_header.last_updated_by := fnd_global.LOGIN_ID();
1344: l_csldtion_inv.trx_header.last_updated_by := fnd_global.USER_ID();----Qiong fix bug 10638369
1337: l_csldtion_inv.trx_header.program_id := fnd_global.CONC_PROGRAM_ID;
1338: l_csldtion_inv.trx_header.program_update_date := SYSDATE;
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1342: l_csldtion_inv.trx_header.last_update_date := SYSDATE;
1343: -- l_csldtion_inv.trx_header.last_updated_by := fnd_global.LOGIN_ID();
1344: l_csldtion_inv.trx_header.last_updated_by := fnd_global.USER_ID();----Qiong fix bug 10638369
1345: l_csldtion_inv.trx_header.last_update_login := fnd_global.LOGIN_ID();
1339: l_csldtion_inv.trx_header.creation_date := SYSDATE;
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1342: l_csldtion_inv.trx_header.last_update_date := SYSDATE;
1343: -- l_csldtion_inv.trx_header.last_updated_by := fnd_global.LOGIN_ID();
1344: l_csldtion_inv.trx_header.last_updated_by := fnd_global.USER_ID();----Qiong fix bug 10638369
1345: l_csldtion_inv.trx_header.last_update_login := fnd_global.LOGIN_ID();
1346: l_csldtion_inv.trx_header.invoice_type :=l_invoice_type;
1347: l_csldtion_inv.trx_header.consolidation_flag :='0';
1340: -- l_csldtion_inv.trx_header.created_by := fnd_global.LOGIN_ID();
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1342: l_csldtion_inv.trx_header.last_update_date := SYSDATE;
1343: -- l_csldtion_inv.trx_header.last_updated_by := fnd_global.LOGIN_ID();
1344: l_csldtion_inv.trx_header.last_updated_by := fnd_global.USER_ID();----Qiong fix bug 10638369
1345: l_csldtion_inv.trx_header.last_update_login := fnd_global.LOGIN_ID();
1346: l_csldtion_inv.trx_header.invoice_type :=l_invoice_type;
1347: l_csldtion_inv.trx_header.consolidation_flag :='0';
1348: --generate group number for consolidation invoice
1341: l_csldtion_inv.trx_header.created_by := fnd_global.USER_ID();--Qiong fix bug 10638369
1342: l_csldtion_inv.trx_header.last_update_date := SYSDATE;
1343: -- l_csldtion_inv.trx_header.last_updated_by := fnd_global.LOGIN_ID();
1344: l_csldtion_inv.trx_header.last_updated_by := fnd_global.USER_ID();----Qiong fix bug 10638369
1345: l_csldtion_inv.trx_header.last_update_login := fnd_global.LOGIN_ID();
1346: l_csldtion_inv.trx_header.invoice_type :=l_invoice_type;
1347: l_csldtion_inv.trx_header.consolidation_flag :='0';
1348: --generate group number for consolidation invoice
1349: BEGIN