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.ASN_MIG_SALES_CREDITS_PVT dependencies on FND_GLOBAL

Line 479: last_updated_by = FND_GLOBAL.user_id,

475: as_leads_all ALA
476: SET
477: ALA.owner_salesforce_id = l_salesforce_ids(i)
478: ,ALA.owner_sales_group_id = l_sales_group_ids(i) ,
479: last_updated_by = FND_GLOBAL.user_id,
480: last_update_date = sysdate,
481: last_update_login = FND_GLOBAL.conc_login_id
482: WHERE
483: ALA.lead_id = l_lead_ids(i)

Line 481: last_update_login = FND_GLOBAL.conc_login_id

477: ALA.owner_salesforce_id = l_salesforce_ids(i)
478: ,ALA.owner_sales_group_id = l_sales_group_ids(i) ,
479: last_updated_by = FND_GLOBAL.user_id,
480: last_update_date = sysdate,
481: last_update_login = FND_GLOBAL.conc_login_id
482: WHERE
483: ALA.lead_id = l_lead_ids(i)
484: AND l_ranks(i) = 1
485: AND (ALA.owner_salesforce_id <> l_salesforce_ids(i)

Line 515: last_updated_by = FND_GLOBAL.user_id,

511: UPDATE
512: as_accesses_all ACS
513: SET
514: owner_flag = 'N',
515: last_updated_by = FND_GLOBAL.user_id,
516: last_update_date = sysdate,
517: last_update_login = FND_GLOBAL.conc_login_id
518: WHERE
519: ACS.lead_id = l_lead_ids(i)

Line 517: last_update_login = FND_GLOBAL.conc_login_id

513: SET
514: owner_flag = 'N',
515: last_updated_by = FND_GLOBAL.user_id,
516: last_update_date = sysdate,
517: last_update_login = FND_GLOBAL.conc_login_id
518: WHERE
519: ACS.lead_id = l_lead_ids(i)
520: AND l_ranks(i) = 1
521: AND ACS.owner_flag = 'Y';

Line 548: last_updated_by = FND_GLOBAL.user_id,

544: as_accesses_all ACS
545: SET
546: owner_flag = 'Y'
547: ,freeze_flag = 'Y' ,
548: last_updated_by = FND_GLOBAL.user_id,
549: last_update_date = sysdate,
550: last_update_login = FND_GLOBAL.conc_login_id
551: WHERE
552: ACS.lead_id = l_lead_ids(i)

Line 550: last_update_login = FND_GLOBAL.conc_login_id

546: owner_flag = 'Y'
547: ,freeze_flag = 'Y' ,
548: last_updated_by = FND_GLOBAL.user_id,
549: last_update_date = sysdate,
550: last_update_login = FND_GLOBAL.conc_login_id
551: WHERE
552: ACS.lead_id = l_lead_ids(i)
553: AND l_ranks(i) = 1
554: AND (ACS.owner_flag = 'N'

Line 608: ,FND_GLOBAL.USER_ID

604: )
605: SELECT
606: AS_ACCESSES_S.nextval
607: ,sysdate
608: ,FND_GLOBAL.USER_ID
609: ,sysdate
610: ,FND_GLOBAL.USER_ID
611: ,FND_GLOBAL.CONC_LOGIN_ID
612: ,NULL

Line 610: ,FND_GLOBAL.USER_ID

606: AS_ACCESSES_S.nextval
607: ,sysdate
608: ,FND_GLOBAL.USER_ID
609: ,sysdate
610: ,FND_GLOBAL.USER_ID
611: ,FND_GLOBAL.CONC_LOGIN_ID
612: ,NULL
613: ,'Y'
614: ,l_customer_ids(i)

Line 611: ,FND_GLOBAL.CONC_LOGIN_ID

607: ,sysdate
608: ,FND_GLOBAL.USER_ID
609: ,sysdate
610: ,FND_GLOBAL.USER_ID
611: ,FND_GLOBAL.CONC_LOGIN_ID
612: ,NULL
613: ,'Y'
614: ,l_customer_ids(i)
615: ,l_salesforce_ids(i)

Line 720: l_user_id number := fnd_global.user_id();

716: l_party_notification_id number;
717: l_orig_itemKey varchar2(30);
718: l_itemKey varchar2(30);
719:
720: l_user_id number := fnd_global.user_id();
721:
722: l_return_status varchar2(1);
723: l_msg_count number;
724: l_msg_data varchar2(2000);

Line 958: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;

954: -- last_update_date should be passed as such to Update API's.
955: -- Passing sysdate will result in an error asking to requery
956: -- the (Dirty) Record
957: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
958: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
959: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;

Line 960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;

956: -- the (Dirty) Record
957: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
958: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
959: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;

Line 961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;

957: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
958: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
959: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
965: l_sc_tbl(1).program_update_date := sysdate;

Line 962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;

958: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
959: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
965: l_sc_tbl(1).program_update_date := sysdate;
966: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;

Line 963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;

959: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
965: l_sc_tbl(1).program_update_date := sysdate;
966: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;
967: l_sc_tbl(1).original_sales_credit_id := l_sc_select_rec.original_sales_credit_id;

Line 964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;

960: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
961: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
962: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
963: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
964: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
965: l_sc_tbl(1).program_update_date := sysdate;
966: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;
967: l_sc_tbl(1).original_sales_credit_id := l_sc_select_rec.original_sales_credit_id;
968: l_sc_tbl(1).lead_id := l_sc_select_rec.lead_id;

Line 1028: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;

1024: -- last_update_date should be passed as such to Update API's.
1025: -- Passing sysdate will result in an error asking to requery
1026: -- the (Dirty) Record
1027: l_ll_tbl(l_ll_tbl_count).last_update_date := ll_select_rec.last_update_date;
1028: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1029: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1030: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;

Line 1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;

1027: l_ll_tbl(l_ll_tbl_count).last_update_date := ll_select_rec.last_update_date;
1028: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1029: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1030: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1033: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1034: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1035: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;

Line 1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;

1028: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1029: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1030: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1033: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1034: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1035: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1036: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;

Line 1033: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;

1029: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1030: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1033: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1034: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1035: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1036: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;
1037: l_ll_tbl(l_ll_tbl_count).lead_line_id := ll_select_rec.lead_line_id;

Line 1034: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;

1030: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1031: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1032: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1033: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1034: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1035: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1036: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;
1037: l_ll_tbl(l_ll_tbl_count).lead_line_id := ll_select_rec.lead_line_id;
1038: l_ll_tbl(l_ll_tbl_count).original_lead_line_id := ll_select_rec.original_lead_line_id;

Line 1226: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;

1222: -- last_update_date should be passed as such to Update API's.
1223: -- Passing sysdate will result in an error asking to requery
1224: -- the (Dirty) Record
1225: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
1226: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
1227: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;

Line 1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;

1224: -- the (Dirty) Record
1225: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
1226: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
1227: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;

Line 1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;

1225: l_sc_tbl(1).last_update_date := l_sc_select_rec.last_update_date;
1226: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
1227: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
1233: l_sc_tbl(1).program_update_date := sysdate;

Line 1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;

1226: l_sc_tbl(1).last_updated_by := FND_GLOBAL.user_id;
1227: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
1233: l_sc_tbl(1).program_update_date := sysdate;
1234: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;

Line 1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;

1227: l_sc_tbl(1).creation_Date := l_sc_select_rec.creation_Date;
1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
1233: l_sc_tbl(1).program_update_date := sysdate;
1234: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;
1235: l_sc_tbl(1).original_sales_credit_id := l_sc_select_rec.original_sales_credit_id;

Line 1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;

1228: l_sc_tbl(1).created_by := FND_GLOBAL.user_id;
1229: l_sc_tbl(1).last_update_login := FND_GLOBAL.conc_login_id;
1230: l_sc_tbl(1).request_id := FND_GLOBAL.conc_request_id;
1231: l_sc_tbl(1).program_application_id := FND_GLOBAL.prog_appl_id;
1232: l_sc_tbl(1).program_id := FND_GLOBAL.conc_program_id;
1233: l_sc_tbl(1).program_update_date := sysdate;
1234: l_sc_tbl(1).sales_credit_id := l_sc_select_rec.sales_credit_id;
1235: l_sc_tbl(1).original_sales_credit_id := l_sc_select_rec.original_sales_credit_id;
1236: l_sc_tbl(1).lead_id := l_sc_select_rec.lead_id;

Line 1296: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;

1292: -- last_update_date should be passed as such to Update API's.
1293: -- Passing sysdate will result in an error asking to requery
1294: -- the (Dirty) Record
1295: l_ll_tbl(l_ll_tbl_count).last_update_date := ll_select_rec.last_update_date;
1296: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1297: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1298: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;

Line 1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;

1295: l_ll_tbl(l_ll_tbl_count).last_update_date := ll_select_rec.last_update_date;
1296: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1297: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1298: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1301: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1302: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1303: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;

Line 1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;

1296: l_ll_tbl(l_ll_tbl_count).last_updated_by := FND_GLOBAL.user_id;
1297: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1298: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1301: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1302: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1303: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1304: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;

Line 1301: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;

1297: l_ll_tbl(l_ll_tbl_count).creation_Date := ll_select_rec.creation_Date;
1298: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1301: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1302: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1303: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1304: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;
1305: l_ll_tbl(l_ll_tbl_count).lead_line_id := ll_select_rec.lead_line_id;

Line 1302: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;

1298: l_ll_tbl(l_ll_tbl_count).created_by := ll_select_rec.created_by;
1299: l_ll_tbl(l_ll_tbl_count).last_update_login := FND_GLOBAL.conc_login_id;
1300: l_ll_tbl(l_ll_tbl_count).request_id := FND_GLOBAL.conc_request_id;
1301: l_ll_tbl(l_ll_tbl_count).program_application_id := FND_GLOBAL.prog_appl_id;
1302: l_ll_tbl(l_ll_tbl_count).program_id := FND_GLOBAL.conc_program_id;
1303: l_ll_tbl(l_ll_tbl_count).program_update_date := sysdate;
1304: l_ll_tbl(l_ll_tbl_count).lead_id := ll_select_rec.lead_id;
1305: l_ll_tbl(l_ll_tbl_count).lead_line_id := ll_select_rec.lead_line_id;
1306: l_ll_tbl(l_ll_tbl_count).original_lead_line_id := ll_select_rec.original_lead_line_id;

Line 1535: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1531: -- Copy lines
1532: AS_LEAD_LINES_PKG.Insert_Row(
1533: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1534: p_LAST_UPDATE_DATE => SYSDATE,
1535: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1536: p_CREATION_DATE => SYSDATE,
1537: p_CREATED_BY => FND_GLOBAL.USER_ID,
1538: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1539: p_REQUEST_ID => lr.REQUEST_ID,

Line 1537: p_CREATED_BY => FND_GLOBAL.USER_ID,

1533: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1534: p_LAST_UPDATE_DATE => SYSDATE,
1535: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1536: p_CREATION_DATE => SYSDATE,
1537: p_CREATED_BY => FND_GLOBAL.USER_ID,
1538: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1539: p_REQUEST_ID => lr.REQUEST_ID,
1540: p_PROGRAM_APPLICATION_ID => lr.PROGRAM_APPLICATION_ID,
1541: p_PROGRAM_ID => lr.PROGRAM_ID,

Line 1538: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1534: p_LAST_UPDATE_DATE => SYSDATE,
1535: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1536: p_CREATION_DATE => SYSDATE,
1537: p_CREATED_BY => FND_GLOBAL.USER_ID,
1538: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1539: p_REQUEST_ID => lr.REQUEST_ID,
1540: p_PROGRAM_APPLICATION_ID => lr.PROGRAM_APPLICATION_ID,
1541: p_PROGRAM_ID => lr.PROGRAM_ID,
1542: p_PROGRAM_UPDATE_DATE => lr.PROGRAM_UPDATE_DATE,

Line 1620: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1616:
1617: AS_SALES_CREDITS_PKG.Insert_Row(
1618: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
1619: p_LAST_UPDATE_DATE => SYSDATE,
1620: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1621: p_CREATION_DATE => SYSDATE,
1622: p_CREATED_BY => FND_GLOBAL.USER_ID,
1623: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1624: p_REQUEST_ID => scr.REQUEST_ID,

Line 1622: p_CREATED_BY => FND_GLOBAL.USER_ID,

1618: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
1619: p_LAST_UPDATE_DATE => SYSDATE,
1620: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1621: p_CREATION_DATE => SYSDATE,
1622: p_CREATED_BY => FND_GLOBAL.USER_ID,
1623: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1624: p_REQUEST_ID => scr.REQUEST_ID,
1625: p_PROGRAM_APPLICATION_ID => scr.PROGRAM_APPLICATION_ID,
1626: p_PROGRAM_ID => scr.PROGRAM_ID,

Line 1623: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1619: p_LAST_UPDATE_DATE => SYSDATE,
1620: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1621: p_CREATION_DATE => SYSDATE,
1622: p_CREATED_BY => FND_GLOBAL.USER_ID,
1623: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1624: p_REQUEST_ID => scr.REQUEST_ID,
1625: p_PROGRAM_APPLICATION_ID => scr.PROGRAM_APPLICATION_ID,
1626: p_PROGRAM_ID => scr.PROGRAM_ID,
1627: p_PROGRAM_UPDATE_DATE => scr.PROGRAM_UPDATE_DATE,

Line 1717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1713: p_COMPETITOR_PRODUCT_ID => cpdr.COMPETITOR_PRODUCT_ID,
1714: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
1715: p_LEAD_ID => P_LEAD_ID,
1716: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
1717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1718: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1719: p_LAST_UPDATE_DATE => SYSDATE,
1720: p_CREATED_BY => FND_GLOBAL.USER_ID,
1721: p_CREATION_DATE => SYSDATE);

Line 1718: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1714: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
1715: p_LEAD_ID => P_LEAD_ID,
1716: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
1717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1718: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1719: p_LAST_UPDATE_DATE => SYSDATE,
1720: p_CREATED_BY => FND_GLOBAL.USER_ID,
1721: p_CREATION_DATE => SYSDATE);
1722:

Line 1720: p_CREATED_BY => FND_GLOBAL.USER_ID,

1716: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
1717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1718: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1719: p_LAST_UPDATE_DATE => SYSDATE,
1720: p_CREATED_BY => FND_GLOBAL.USER_ID,
1721: p_CREATION_DATE => SYSDATE);
1722:
1723: IF l_lead_competitor_prod_id is null THEN
1724: IF l_debug THEN

Line 1768: p_CREATE_BY => FND_GLOBAL.USER_ID,

1764: p_DECISION_PRIORITY_CODE => dfcr.DECISION_PRIORITY_CODE,
1765: p_DECISION_FACTOR_CODE => dfcr.DECISION_FACTOR_CODE,
1766: px_LEAD_DECISION_FACTOR_ID => l_LEAD_DECISION_FACTOR_ID,
1767: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
1768: p_CREATE_BY => FND_GLOBAL.USER_ID,
1769: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1770: p_LAST_UPDATE_DATE => SYSDATE,
1771: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1772: p_CREATION_DATE => SYSDATE);

Line 1769: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1765: p_DECISION_FACTOR_CODE => dfcr.DECISION_FACTOR_CODE,
1766: px_LEAD_DECISION_FACTOR_ID => l_LEAD_DECISION_FACTOR_ID,
1767: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
1768: p_CREATE_BY => FND_GLOBAL.USER_ID,
1769: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1770: p_LAST_UPDATE_DATE => SYSDATE,
1771: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1772: p_CREATION_DATE => SYSDATE);
1773:

Line 1771: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1767: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
1768: p_CREATE_BY => FND_GLOBAL.USER_ID,
1769: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1770: p_LAST_UPDATE_DATE => SYSDATE,
1771: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1772: p_CREATION_DATE => SYSDATE);
1773:
1774: IF l_lead_decision_factor_id is null THEN
1775: IF l_debug THEN

Line 2336: l_user_id := FND_GLOBAL.user_id;

2332: ',p_end_id='||p_end_id ||
2333: ',p_debug_flag='||p_debug_flag);
2334: END IF;
2335:
2336: l_user_id := FND_GLOBAL.user_id;
2337:
2338: IF l_user_id IS NULL THEN
2339: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,

Line 2412: last_updated_by = FND_GLOBAL.user_id,

2408:
2409: FORALL I IN l_lead_id.first..l_lead_id.last
2410: update as_lead_lines_all
2411: set forecast_date = NULL, rolling_forecast_flag = 'N' ,
2412: last_updated_by = FND_GLOBAL.user_id,
2413: last_update_date = sysdate,
2414: last_update_login = FND_GLOBAL.conc_login_id
2415: where lead_id = l_lead_id(i) and rolling_forecast_flag = 'Y';
2416:

Line 2414: last_update_login = FND_GLOBAL.conc_login_id

2410: update as_lead_lines_all
2411: set forecast_date = NULL, rolling_forecast_flag = 'N' ,
2412: last_updated_by = FND_GLOBAL.user_id,
2413: last_update_date = sysdate,
2414: last_update_login = FND_GLOBAL.conc_login_id
2415: where lead_id = l_lead_id(i) and rolling_forecast_flag = 'Y';
2416:
2417: --Place for Bad Data --- Start
2418: FOR I IN l_lead_id.first..l_lead_id.last

Line 2456: last_updated_by = FND_GLOBAL.user_id,

2452: CREDIT_AMOUNT = (select total_amount
2453: from as_lead_lines oppl
2454: where oppl.lead_id = ascr.lead_id
2455: and oppl.lead_line_id = ascr.lead_line_id ),
2456: last_updated_by = FND_GLOBAL.user_id,
2457: last_update_date = sysdate,
2458: last_update_login = FND_GLOBAL.conc_login_id
2459: where ascr.lead_id = l_lead_id(i) and NVL(CREDIT_PERCENT,0) <> 100
2460: and CREDIT_TYPE_ID in

Line 2458: last_update_login = FND_GLOBAL.conc_login_id

2454: where oppl.lead_id = ascr.lead_id
2455: and oppl.lead_line_id = ascr.lead_line_id ),
2456: last_updated_by = FND_GLOBAL.user_id,
2457: last_update_date = sysdate,
2458: last_update_login = FND_GLOBAL.conc_login_id
2459: where ascr.lead_id = l_lead_id(i) and NVL(CREDIT_PERCENT,0) <> 100
2460: and CREDIT_TYPE_ID in
2461: ( select SALES_CREDIT_TYPE_ID
2462: from oe_sales_credit_types

Line 2499: last_updated_by = FND_GLOBAL.user_id,

2495: -- bug#4150276 and as per wenxia's email 28 Jan 2005 18:30:21 -0800
2496: FORALL I IN l_lead_id.first..l_lead_id.last
2497: UPDATE as_accesses_all acc
2498: SET acc.team_leader_flag = 'Y',
2499: last_updated_by = FND_GLOBAL.user_id,
2500: last_update_date = sysdate,
2501: last_update_login = FND_GLOBAL.conc_login_id
2502: WHERE acc.lead_id is not null
2503: AND acc.lead_id = l_lead_id(i)

Line 2501: last_update_login = FND_GLOBAL.conc_login_id

2497: UPDATE as_accesses_all acc
2498: SET acc.team_leader_flag = 'Y',
2499: last_updated_by = FND_GLOBAL.user_id,
2500: last_update_date = sysdate,
2501: last_update_login = FND_GLOBAL.conc_login_id
2502: WHERE acc.lead_id is not null
2503: AND acc.lead_id = l_lead_id(i)
2504: AND nvl(acc.team_leader_flag,'N') <> 'Y'
2505: AND (

Line 2590: last_updated_by = FND_GLOBAL.user_id,

2586: l_org_owner_sg_id := l_sg_id;
2587: -- Reset current owner flag.
2588: UPDATE as_accesses_all
2589: SET owner_flag = 'N' ,
2590: last_updated_by = FND_GLOBAL.user_id,
2591: last_update_date = sysdate,
2592: last_update_login = FND_GLOBAL.conc_login_id
2593: WHERE lead_id = l_lead_id(j) AND owner_flag = 'Y';
2594:

Line 2592: last_update_login = FND_GLOBAL.conc_login_id

2588: UPDATE as_accesses_all
2589: SET owner_flag = 'N' ,
2590: last_updated_by = FND_GLOBAL.user_id,
2591: last_update_date = sysdate,
2592: last_update_login = FND_GLOBAL.conc_login_id
2593: WHERE lead_id = l_lead_id(j) AND owner_flag = 'Y';
2594:
2595: -- Reassign owner flag;
2596: UPDATE as_accesses_all

Line 2599: last_updated_by = FND_GLOBAL.user_id,

2595: -- Reassign owner flag;
2596: UPDATE as_accesses_all
2597: SET owner_flag = 'Y', team_leader_flag = 'Y',
2598: freeze_flag = 'Y',
2599: last_updated_by = FND_GLOBAL.user_id,
2600: last_update_date = sysdate,
2601: last_update_login = FND_GLOBAL.conc_login_id
2602: WHERE lead_id = l_lead_id(j) AND
2603: salesforce_id = l_org_owner_sf_id AND

Line 2601: last_update_login = FND_GLOBAL.conc_login_id

2597: SET owner_flag = 'Y', team_leader_flag = 'Y',
2598: freeze_flag = 'Y',
2599: last_updated_by = FND_GLOBAL.user_id,
2600: last_update_date = sysdate,
2601: last_update_login = FND_GLOBAL.conc_login_id
2602: WHERE lead_id = l_lead_id(j) AND
2603: salesforce_id = l_org_owner_sf_id AND
2604: nvl(sales_group_id, -37) = nvl(l_org_owner_sg_id, -37);
2605:

Line 2636: ,FND_GLOBAL.user_id

2632: )
2633: VALUES(
2634: AS_ACCESSES_S.nextval
2635: ,sysdate
2636: ,FND_GLOBAL.user_id
2637: ,sysdate
2638: ,FND_GLOBAL.user_id
2639: ,FND_GLOBAL.conc_login_id
2640: ,NULL

Line 2638: ,FND_GLOBAL.user_id

2634: AS_ACCESSES_S.nextval
2635: ,sysdate
2636: ,FND_GLOBAL.user_id
2637: ,sysdate
2638: ,FND_GLOBAL.user_id
2639: ,FND_GLOBAL.conc_login_id
2640: ,NULL
2641: ,'Y'
2642: ,l_customer_id(j)

Line 2639: ,FND_GLOBAL.conc_login_id

2635: ,sysdate
2636: ,FND_GLOBAL.user_id
2637: ,sysdate
2638: ,FND_GLOBAL.user_id
2639: ,FND_GLOBAL.conc_login_id
2640: ,NULL
2641: ,'Y'
2642: ,l_customer_id(j)
2643: ,l_org_owner_sf_id

Line 2676: last_updated_by = FND_GLOBAL.user_id,

2672:
2673: UPDATE AS_ACCESSES_ALL
2674: SET owner_flag = 'Y', team_leader_flag = 'Y',
2675: freeze_flag = 'Y',
2676: last_updated_by = FND_GLOBAL.user_id,
2677: last_update_date = sysdate,
2678: last_update_login = FND_GLOBAL.conc_login_id
2679: WHERE access_id = l_access_id;
2680: END IF;

Line 2678: last_update_login = FND_GLOBAL.conc_login_id

2674: SET owner_flag = 'Y', team_leader_flag = 'Y',
2675: freeze_flag = 'Y',
2676: last_updated_by = FND_GLOBAL.user_id,
2677: last_update_date = sysdate,
2678: last_update_login = FND_GLOBAL.conc_login_id
2679: WHERE access_id = l_access_id;
2680: END IF;
2681: END IF;
2682:

Line 2688: last_updated_by = FND_GLOBAL.user_id,

2684:
2685: UPDATE as_leads_all
2686: SET owner_salesforce_id = l_org_owner_sf_id,
2687: owner_sales_group_id = l_org_owner_sg_id,
2688: last_updated_by = FND_GLOBAL.user_id,
2689: last_update_date = sysdate,
2690: last_update_login = FND_GLOBAL.conc_login_id
2691: WHERE lead_id = l_lead_id(j);
2692:

Line 2690: last_update_login = FND_GLOBAL.conc_login_id

2686: SET owner_salesforce_id = l_org_owner_sf_id,
2687: owner_sales_group_id = l_org_owner_sg_id,
2688: last_updated_by = FND_GLOBAL.user_id,
2689: last_update_date = sysdate,
2690: last_update_login = FND_GLOBAL.conc_login_id
2691: WHERE lead_id = l_lead_id(j);
2692:
2693: IF (p_debug_flag = 'Y' AND
2694: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2723: last_updated_by = FND_GLOBAL.user_id,

2719: SET salesforce_id = l_org_owner_sf_id,
2720: salesgroup_id = l_org_owner_sg_id,
2721: person_id = l_org_owner_person_id,
2722: partner_customer_id = NULL, partner_address_id = NULL,
2723: last_updated_by = FND_GLOBAL.user_id,
2724: last_update_date = sysdate,
2725: last_update_login = FND_GLOBAL.conc_login_id
2726: WHERE lead_id = l_lead_id(j)
2727: AND credit_type_id = l_forecast_credit_type_id

Line 2725: last_update_login = FND_GLOBAL.conc_login_id

2721: person_id = l_org_owner_person_id,
2722: partner_customer_id = NULL, partner_address_id = NULL,
2723: last_updated_by = FND_GLOBAL.user_id,
2724: last_update_date = sysdate,
2725: last_update_login = FND_GLOBAL.conc_login_id
2726: WHERE lead_id = l_lead_id(j)
2727: AND credit_type_id = l_forecast_credit_type_id
2728: AND partner_customer_id IS NOT NULL;
2729: END IF;

Line 2869: FND_GLOBAL.USER_ID,

2865: 'Y',
2866: 'N',
2867: 'Y',
2868: SYSDATE,
2869: FND_GLOBAL.USER_ID,
2870: SYSDATE,
2871: FND_GLOBAL.USER_ID,
2872: FND_GLOBAL.CONC_LOGIN_ID,
2873: FND_GLOBAL.PROG_APPL_ID,

Line 2871: FND_GLOBAL.USER_ID,

2867: 'Y',
2868: SYSDATE,
2869: FND_GLOBAL.USER_ID,
2870: SYSDATE,
2871: FND_GLOBAL.USER_ID,
2872: FND_GLOBAL.CONC_LOGIN_ID,
2873: FND_GLOBAL.PROG_APPL_ID,
2874: FND_GLOBAL.CONC_PROGRAM_ID,
2875: SYSDATE,

Line 2872: FND_GLOBAL.CONC_LOGIN_ID,

2868: SYSDATE,
2869: FND_GLOBAL.USER_ID,
2870: SYSDATE,
2871: FND_GLOBAL.USER_ID,
2872: FND_GLOBAL.CONC_LOGIN_ID,
2873: FND_GLOBAL.PROG_APPL_ID,
2874: FND_GLOBAL.CONC_PROGRAM_ID,
2875: SYSDATE,
2876: 1.0,

Line 2873: FND_GLOBAL.PROG_APPL_ID,

2869: FND_GLOBAL.USER_ID,
2870: SYSDATE,
2871: FND_GLOBAL.USER_ID,
2872: FND_GLOBAL.CONC_LOGIN_ID,
2873: FND_GLOBAL.PROG_APPL_ID,
2874: FND_GLOBAL.CONC_PROGRAM_ID,
2875: SYSDATE,
2876: 1.0,
2877: l_open_status_flag(j));

Line 2874: FND_GLOBAL.CONC_PROGRAM_ID,

2870: SYSDATE,
2871: FND_GLOBAL.USER_ID,
2872: FND_GLOBAL.CONC_LOGIN_ID,
2873: FND_GLOBAL.PROG_APPL_ID,
2874: FND_GLOBAL.CONC_PROGRAM_ID,
2875: SYSDATE,
2876: 1.0,
2877: l_open_status_flag(j));
2878: END LOOP;

Line 2887: last_updated_by = FND_GLOBAL.user_id,

2883: SET salesforce_id = l_org_owner_sf_id,
2884: salesgroup_id = l_org_owner_sg_id,
2885: person_id = l_org_owner_person_id,
2886: partner_customer_id = NULL, partner_address_id = NULL,
2887: last_updated_by = FND_GLOBAL.user_id,
2888: last_update_date = sysdate,
2889: last_update_login = FND_GLOBAL.conc_login_id
2890: WHERE lead_id = l_lead_id(j)
2891: AND credit_type_id <> l_forecast_credit_type_id

Line 2889: last_update_login = FND_GLOBAL.conc_login_id

2885: person_id = l_org_owner_person_id,
2886: partner_customer_id = NULL, partner_address_id = NULL,
2887: last_updated_by = FND_GLOBAL.user_id,
2888: last_update_date = sysdate,
2889: last_update_login = FND_GLOBAL.conc_login_id
2890: WHERE lead_id = l_lead_id(j)
2891: AND credit_type_id <> l_forecast_credit_type_id
2892: AND partner_customer_id IS NOT NULL;
2893: END IF;

Line 2902: last_updated_by = FND_GLOBAL.user_id,

2898: -- has the DEFAULTED_FROM_OWNER_FLAG flag set
2899: FORALL I IN l_lead_id.first..l_lead_id.last
2900: update as_sales_Credits ascr
2901: set DEFAULTED_FROM_OWNER_FLAG = 'Y',
2902: last_updated_by = FND_GLOBAL.user_id,
2903: last_update_date = sysdate,
2904: last_update_login = FND_GLOBAL.conc_login_id
2905: where ascr.lead_id = l_lead_id(i)
2906: and NVL(DEFAULTED_FROM_OWNER_FLAG,'N') <> 'Y'

Line 2904: last_update_login = FND_GLOBAL.conc_login_id

2900: update as_sales_Credits ascr
2901: set DEFAULTED_FROM_OWNER_FLAG = 'Y',
2902: last_updated_by = FND_GLOBAL.user_id,
2903: last_update_date = sysdate,
2904: last_update_login = FND_GLOBAL.conc_login_id
2905: where ascr.lead_id = l_lead_id(i)
2906: and NVL(DEFAULTED_FROM_OWNER_FLAG,'N') <> 'Y'
2907: and (SALESFORCE_ID ,SALESGROUP_ID) in
2908: (SELECT owner_salesforce_id,owner_sales_group_id