DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FND_GLOBAL

Line 3006: l_user_id number := FND_GLOBAL.USER_ID;

3002: l_use_bank_charge_flag VARCHAR2(255);
3003: l_bank_charge_bearer VARCHAR2(255);
3004: l_hold_unmatched_invoices_flag VARCHAR2(1);
3005:
3006: l_user_id number := FND_GLOBAL.USER_ID;
3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3009: l_program_id number := FND_GLOBAL.conc_program_id;
3010: l_request_id number := FND_GLOBAL.conc_request_id;

Line 3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

3003: l_bank_charge_bearer VARCHAR2(255);
3004: l_hold_unmatched_invoices_flag VARCHAR2(1);
3005:
3006: l_user_id number := FND_GLOBAL.USER_ID;
3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3009: l_program_id number := FND_GLOBAL.conc_program_id;
3010: l_request_id number := FND_GLOBAL.conc_request_id;
3011: l_val_return_status VARCHAR2(50);

Line 3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;

3004: l_hold_unmatched_invoices_flag VARCHAR2(1);
3005:
3006: l_user_id number := FND_GLOBAL.USER_ID;
3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3009: l_program_id number := FND_GLOBAL.conc_program_id;
3010: l_request_id number := FND_GLOBAL.conc_request_id;
3011: l_val_return_status VARCHAR2(50);
3012: l_val_msg_count NUMBER;

Line 3009: l_program_id number := FND_GLOBAL.conc_program_id;

3005:
3006: l_user_id number := FND_GLOBAL.USER_ID;
3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3009: l_program_id number := FND_GLOBAL.conc_program_id;
3010: l_request_id number := FND_GLOBAL.conc_request_id;
3011: l_val_return_status VARCHAR2(50);
3012: l_val_msg_count NUMBER;
3013: l_val_msg_data VARCHAR2(1000);

Line 3010: l_request_id number := FND_GLOBAL.conc_request_id;

3006: l_user_id number := FND_GLOBAL.USER_ID;
3007: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3008: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3009: l_program_id number := FND_GLOBAL.conc_program_id;
3010: l_request_id number := FND_GLOBAL.conc_request_id;
3011: l_val_return_status VARCHAR2(50);
3012: l_val_msg_count NUMBER;
3013: l_val_msg_data VARCHAR2(1000);
3014: l_creation_date DATE;

Line 3112: l_last_update_login := fnd_global.login_id;

3108: --in the initialization procedure will no longer be defaulted at
3109: --the supplier level because system parameters are org specific
3110: l_vendor_rec.summary_flag := nvl(l_vendor_rec.summary_flag, 'N');
3111: l_vendor_rec.enabled_flag := nvl(l_vendor_rec.enabled_flag, 'Y');
3112: l_last_update_login := fnd_global.login_id;
3113: l_creation_date := sysdate;
3114: l_created_by := fnd_global.user_id;
3115: l_vendor_rec.one_time_flag := nvl(l_vendor_rec.one_time_flag,'N');
3116:

Line 3114: l_created_by := fnd_global.user_id;

3110: l_vendor_rec.summary_flag := nvl(l_vendor_rec.summary_flag, 'N');
3111: l_vendor_rec.enabled_flag := nvl(l_vendor_rec.enabled_flag, 'Y');
3112: l_last_update_login := fnd_global.login_id;
3113: l_creation_date := sysdate;
3114: l_created_by := fnd_global.user_id;
3115: l_vendor_rec.one_time_flag := nvl(l_vendor_rec.one_time_flag,'N');
3116:
3117: -- Bug 6085640 - Terms ID should not be set to default if Terms Name
3118: -- has been given.

Line 3531: l_user_id number := FND_GLOBAL.USER_ID;

3527:
3528: l_def_org_id NUMBER;
3529: l_org_context VARCHAR2(1);
3530:
3531: l_user_id number := FND_GLOBAL.USER_ID;
3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3534: l_program_id number := FND_GLOBAL.conc_program_id;
3535: l_request_id number := FND_GLOBAL.conc_request_id;

Line 3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

3528: l_def_org_id NUMBER;
3529: l_org_context VARCHAR2(1);
3530:
3531: l_user_id number := FND_GLOBAL.USER_ID;
3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3534: l_program_id number := FND_GLOBAL.conc_program_id;
3535: l_request_id number := FND_GLOBAL.conc_request_id;
3536:

Line 3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;

3529: l_org_context VARCHAR2(1);
3530:
3531: l_user_id number := FND_GLOBAL.USER_ID;
3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3534: l_program_id number := FND_GLOBAL.conc_program_id;
3535: l_request_id number := FND_GLOBAL.conc_request_id;
3536:
3537: l_vendor_rec r_vendor_rec_type;

Line 3534: l_program_id number := FND_GLOBAL.conc_program_id;

3530:
3531: l_user_id number := FND_GLOBAL.USER_ID;
3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3534: l_program_id number := FND_GLOBAL.conc_program_id;
3535: l_request_id number := FND_GLOBAL.conc_request_id;
3536:
3537: l_vendor_rec r_vendor_rec_type;
3538: l_val_return_status VARCHAR2(50);

Line 3535: l_request_id number := FND_GLOBAL.conc_request_id;

3531: l_user_id number := FND_GLOBAL.USER_ID;
3532: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
3533: l_program_application_id number := FND_GLOBAL.prog_appl_id;
3534: l_program_id number := FND_GLOBAL.conc_program_id;
3535: l_request_id number := FND_GLOBAL.conc_request_id;
3536:
3537: l_vendor_rec r_vendor_rec_type;
3538: l_val_return_status VARCHAR2(50);
3539: l_val_msg_count NUMBER;

Line 6974: l_user_id number := FND_GLOBAL.USER_ID;

6970: l_accts_pay_ccid_def VARCHAR2(255);
6971: l_prepay_ccid_def VARCHAR2(255);
6972: l_future_pay_ccid_def VARCHAR2(255);
6973:
6974: l_user_id number := FND_GLOBAL.USER_ID;
6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;
6977: l_program_id number := FND_GLOBAL.conc_program_id;
6978: l_request_id number := FND_GLOBAL.conc_request_id;

Line 6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

6971: l_prepay_ccid_def VARCHAR2(255);
6972: l_future_pay_ccid_def VARCHAR2(255);
6973:
6974: l_user_id number := FND_GLOBAL.USER_ID;
6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;
6977: l_program_id number := FND_GLOBAL.conc_program_id;
6978: l_request_id number := FND_GLOBAL.conc_request_id;
6979:

Line 6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;

6972: l_future_pay_ccid_def VARCHAR2(255);
6973:
6974: l_user_id number := FND_GLOBAL.USER_ID;
6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;
6977: l_program_id number := FND_GLOBAL.conc_program_id;
6978: l_request_id number := FND_GLOBAL.conc_request_id;
6979:
6980: l_val_return_status VARCHAR2(50);

Line 6977: l_program_id number := FND_GLOBAL.conc_program_id;

6973:
6974: l_user_id number := FND_GLOBAL.USER_ID;
6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;
6977: l_program_id number := FND_GLOBAL.conc_program_id;
6978: l_request_id number := FND_GLOBAL.conc_request_id;
6979:
6980: l_val_return_status VARCHAR2(50);
6981: l_val_msg_count NUMBER;

Line 6978: l_request_id number := FND_GLOBAL.conc_request_id;

6974: l_user_id number := FND_GLOBAL.USER_ID;
6975: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
6976: l_program_application_id number := FND_GLOBAL.prog_appl_id;
6977: l_program_id number := FND_GLOBAL.conc_program_id;
6978: l_request_id number := FND_GLOBAL.conc_request_id;
6979:
6980: l_val_return_status VARCHAR2(50);
6981: l_val_msg_count NUMBER;
6982: l_val_msg_data VARCHAR2(2000);

Line 7356: l_last_updated_by := fnd_global.user_id;

7352: ap_system_parameters_all asp
7353: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
7354: AND asp.org_id=l_def_org_id;
7355:
7356: l_last_updated_by := fnd_global.user_id;
7357: l_last_update_login := fnd_global.login_id;
7358: l_created_by := fnd_global.user_id;
7359:
7360: --Bug6679696

Line 7357: l_last_update_login := fnd_global.login_id;

7353: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
7354: AND asp.org_id=l_def_org_id;
7355:
7356: l_last_updated_by := fnd_global.user_id;
7357: l_last_update_login := fnd_global.login_id;
7358: l_created_by := fnd_global.user_id;
7359:
7360: --Bug6679696
7361: IF l_vendor_type_lookup_code = 'EMPLOYEE' then

Line 7358: l_created_by := fnd_global.user_id;

7354: AND asp.org_id=l_def_org_id;
7355:
7356: l_last_updated_by := fnd_global.user_id;
7357: l_last_update_login := fnd_global.login_id;
7358: l_created_by := fnd_global.user_id;
7359:
7360: --Bug6679696
7361: IF l_vendor_type_lookup_code = 'EMPLOYEE' then
7362: l_vendor_site_rec.pay_site_flag := nvl(l_vendor_site_rec.pay_site_flag,'Y');

Line 7973: l_user_id number := FND_GLOBAL.USER_ID;

7969: l_api_version CONSTANT NUMBER := 1.0;
7970:
7971: l_def_org_id NUMBER;
7972:
7973: l_user_id number := FND_GLOBAL.USER_ID;
7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7976: l_program_id number := FND_GLOBAL.conc_program_id;
7977: l_request_id number := FND_GLOBAL.conc_request_id;

Line 7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

7970:
7971: l_def_org_id NUMBER;
7972:
7973: l_user_id number := FND_GLOBAL.USER_ID;
7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7976: l_program_id number := FND_GLOBAL.conc_program_id;
7977: l_request_id number := FND_GLOBAL.conc_request_id;
7978: l_vendor_site_rec r_vendor_site_rec_type;

Line 7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;

7971: l_def_org_id NUMBER;
7972:
7973: l_user_id number := FND_GLOBAL.USER_ID;
7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7976: l_program_id number := FND_GLOBAL.conc_program_id;
7977: l_request_id number := FND_GLOBAL.conc_request_id;
7978: l_vendor_site_rec r_vendor_site_rec_type;
7979: l_org_context VARCHAR2(1);

Line 7976: l_program_id number := FND_GLOBAL.conc_program_id;

7972:
7973: l_user_id number := FND_GLOBAL.USER_ID;
7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7976: l_program_id number := FND_GLOBAL.conc_program_id;
7977: l_request_id number := FND_GLOBAL.conc_request_id;
7978: l_vendor_site_rec r_vendor_site_rec_type;
7979: l_org_context VARCHAR2(1);
7980: l_val_return_status VARCHAR2(50);

Line 7977: l_request_id number := FND_GLOBAL.conc_request_id;

7973: l_user_id number := FND_GLOBAL.USER_ID;
7974: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
7975: l_program_application_id number := FND_GLOBAL.prog_appl_id;
7976: l_program_id number := FND_GLOBAL.conc_program_id;
7977: l_request_id number := FND_GLOBAL.conc_request_id;
7978: l_vendor_site_rec r_vendor_site_rec_type;
7979: l_org_context VARCHAR2(1);
7980: l_val_return_status VARCHAR2(50);
7981: l_val_msg_count NUMBER;

Line 11416: l_user_id number := FND_GLOBAL.USER_ID;

11412: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
11413: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
11414: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
11415:
11416: l_user_id number := FND_GLOBAL.USER_ID;
11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;
11419: l_program_id number := FND_GLOBAL.conc_program_id;
11420: l_request_id number := FND_GLOBAL.conc_request_id;

Line 11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

11413: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
11414: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
11415:
11416: l_user_id number := FND_GLOBAL.USER_ID;
11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;
11419: l_program_id number := FND_GLOBAL.conc_program_id;
11420: l_request_id number := FND_GLOBAL.conc_request_id;
11421:

Line 11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;

11414: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
11415:
11416: l_user_id number := FND_GLOBAL.USER_ID;
11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;
11419: l_program_id number := FND_GLOBAL.conc_program_id;
11420: l_request_id number := FND_GLOBAL.conc_request_id;
11421:
11422: l_val_return_status VARCHAR2(50);

Line 11419: l_program_id number := FND_GLOBAL.conc_program_id;

11415:
11416: l_user_id number := FND_GLOBAL.USER_ID;
11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;
11419: l_program_id number := FND_GLOBAL.conc_program_id;
11420: l_request_id number := FND_GLOBAL.conc_request_id;
11421:
11422: l_val_return_status VARCHAR2(50);
11423: l_val_msg_count NUMBER;

Line 11420: l_request_id number := FND_GLOBAL.conc_request_id;

11416: l_user_id number := FND_GLOBAL.USER_ID;
11417: l_last_update_login number := FND_GLOBAL.LOGIN_ID;
11418: l_program_application_id number := FND_GLOBAL.prog_appl_id;
11419: l_program_id number := FND_GLOBAL.conc_program_id;
11420: l_request_id number := FND_GLOBAL.conc_request_id;
11421:
11422: l_val_return_status VARCHAR2(50);
11423: l_val_msg_count NUMBER;
11424: l_val_msg_data VARCHAR2(1000);

Line 11969: nvl(fnd_global.user_id,-1),

11965: l_vendor_contact_rec.org_party_site_id,
11966: --l_vendor_contact_rec.vendor_site_id, Bug 7013954 Vendor Site info no longer used
11967: l_vendor_contact_rec.vendor_contact_id,
11968: SYSDATE,
11969: nvl(fnd_global.user_id,-1),
11970: SYSDATE,
11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),

Line 11971: nvl(fnd_global.user_id,-1),

11967: l_vendor_contact_rec.vendor_contact_id,
11968: SYSDATE,
11969: nvl(fnd_global.user_id,-1),
11970: SYSDATE,
11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),
11974: nvl(FND_GLOBAL.prog_appl_id,-1),
11975: nvl(FND_GLOBAL.conc_program_id,-1),

Line 11972: nvl(fnd_global.login_id,-1),

11968: SYSDATE,
11969: nvl(fnd_global.user_id,-1),
11970: SYSDATE,
11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),
11974: nvl(FND_GLOBAL.prog_appl_id,-1),
11975: nvl(FND_GLOBAL.conc_program_id,-1),
11976: sysdate,

Line 11973: nvl(FND_GLOBAL.conc_request_id,-1),

11969: nvl(fnd_global.user_id,-1),
11970: SYSDATE,
11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),
11974: nvl(FND_GLOBAL.prog_appl_id,-1),
11975: nvl(FND_GLOBAL.conc_program_id,-1),
11976: sysdate,
11977: l_vendor_contact_rec.inactive_date, --Bug 4994974

Line 11974: nvl(FND_GLOBAL.prog_appl_id,-1),

11970: SYSDATE,
11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),
11974: nvl(FND_GLOBAL.prog_appl_id,-1),
11975: nvl(FND_GLOBAL.conc_program_id,-1),
11976: sysdate,
11977: l_vendor_contact_rec.inactive_date, --Bug 4994974
11978: l_vendor_contact_rec.attribute_category, --bug 6745669 -- added dff columns

Line 11975: nvl(FND_GLOBAL.conc_program_id,-1),

11971: nvl(fnd_global.user_id,-1),
11972: nvl(fnd_global.login_id,-1),
11973: nvl(FND_GLOBAL.conc_request_id,-1),
11974: nvl(FND_GLOBAL.prog_appl_id,-1),
11975: nvl(FND_GLOBAL.conc_program_id,-1),
11976: sysdate,
11977: l_vendor_contact_rec.inactive_date, --Bug 4994974
11978: l_vendor_contact_rec.attribute_category, --bug 6745669 -- added dff columns
11979: l_vendor_contact_rec.attribute1,

Line 12708: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

12704:
12705: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendors';
12706: l_api_version CONSTANT NUMBER := 1.0;
12707:
12708: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
12709: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
12710: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
12711:
12712: l_return_status VARCHAR2(2000);

Line 12709: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

12705: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendors';
12706: l_api_version CONSTANT NUMBER := 1.0;
12707:
12708: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
12709: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
12710: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
12711:
12712: l_return_status VARCHAR2(2000);
12713: l_msg_count NUMBER;

Line 12710: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

12706: l_api_version CONSTANT NUMBER := 1.0;
12707:
12708: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
12709: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
12710: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
12711:
12712: l_return_status VARCHAR2(2000);
12713: l_msg_count NUMBER;
12714: l_msg_data VARCHAR2(2000);

Line 12768: g_user_id := FND_GLOBAL.USER_ID;

12764: END IF;
12765:
12766: FND_MSG_PUB.initialize;
12767:
12768: g_user_id := FND_GLOBAL.USER_ID;
12769: g_login_id := FND_GLOBAL.LOGIN_ID;
12770: g_source := p_source;
12771: -- Initialize API return status to success
12772: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12769: g_login_id := FND_GLOBAL.LOGIN_ID;

12765:
12766: FND_MSG_PUB.initialize;
12767:
12768: g_user_id := FND_GLOBAL.USER_ID;
12769: g_login_id := FND_GLOBAL.LOGIN_ID;
12770: g_source := p_source;
12771: -- Initialize API return status to success
12772: x_return_status := FND_API.G_RET_STS_SUCCESS;
12773:

Line 13273: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

13269:
13270: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Sites';
13271: l_api_version CONSTANT NUMBER := 1.0;
13272:
13273: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13274: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13275: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13276:
13277: l_return_status VARCHAR2(2000);

Line 13274: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

13270: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Sites';
13271: l_api_version CONSTANT NUMBER := 1.0;
13272:
13273: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13274: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13275: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13276:
13277: l_return_status VARCHAR2(2000);
13278: l_msg_count NUMBER;

Line 13275: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

13271: l_api_version CONSTANT NUMBER := 1.0;
13272:
13273: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13274: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13275: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13276:
13277: l_return_status VARCHAR2(2000);
13278: l_msg_count NUMBER;
13279: l_msg_data VARCHAR2(2000);

Line 13335: g_user_id := FND_GLOBAL.USER_ID;

13331: END IF;
13332:
13333: FND_MSG_PUB.initialize;
13334:
13335: g_user_id := FND_GLOBAL.USER_ID;
13336: g_login_id := FND_GLOBAL.LOGIN_ID;
13337: g_source := p_source;
13338: -- Initialize API return status to success
13339: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13336: g_login_id := FND_GLOBAL.LOGIN_ID;

13332:
13333: FND_MSG_PUB.initialize;
13334:
13335: g_user_id := FND_GLOBAL.USER_ID;
13336: g_login_id := FND_GLOBAL.LOGIN_ID;
13337: g_source := p_source;
13338: -- Initialize API return status to success
13339: x_return_status := FND_API.G_RET_STS_SUCCESS;
13340:

Line 13905: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

13901:
13902: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Contacts';
13903: l_api_version CONSTANT NUMBER := 1.0;
13904:
13905: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13906: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13907: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13908:
13909: l_return_status VARCHAR2(2000);

Line 13906: l_program_id NUMBER := FND_GLOBAL.conc_program_id;

13902: l_api_name CONSTANT VARCHAR2(30) := 'Import_Vendor_Contacts';
13903: l_api_version CONSTANT NUMBER := 1.0;
13904:
13905: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13906: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13907: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13908:
13909: l_return_status VARCHAR2(2000);
13910: l_msg_count NUMBER;

Line 13907: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

13903: l_api_version CONSTANT NUMBER := 1.0;
13904:
13905: l_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
13906: l_program_id NUMBER := FND_GLOBAL.conc_program_id;
13907: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
13908:
13909: l_return_status VARCHAR2(2000);
13910: l_msg_count NUMBER;
13911: l_msg_data VARCHAR2(2000);

Line 13950: g_user_id := FND_GLOBAL.USER_ID;

13946: END IF;
13947:
13948: FND_MSG_PUB.initialize;
13949:
13950: g_user_id := FND_GLOBAL.USER_ID;
13951: g_login_id := FND_GLOBAL.LOGIN_ID;
13952: g_source := p_source;
13953: -- Initialize API return status to success
13954: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13951: g_login_id := FND_GLOBAL.LOGIN_ID;

13947:
13948: FND_MSG_PUB.initialize;
13949:
13950: g_user_id := FND_GLOBAL.USER_ID;
13951: g_login_id := FND_GLOBAL.LOGIN_ID;
13952: g_source := p_source;
13953: -- Initialize API return status to success
13954: x_return_status := FND_API.G_RET_STS_SUCCESS;
13955: