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;
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);
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;
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);
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;
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:
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.
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;
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:
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;
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);
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;
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;
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:
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);
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;
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);
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
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
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');
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;
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;
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);
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);
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;
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;
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:
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);
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;
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);
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),
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),
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,
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
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
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,
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);
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;
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);
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;
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:
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);
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;
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);
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;
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:
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);
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;
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);
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;
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: