DBA Data[Home] [Help]

APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on FND_GLOBAL

Line 308: l_user_id := fnd_global.user_id;

304: AND NOT EXISTS (SELECT named_account_id
305: from JTF_TTY_NAMED_ACCTS a
306: where a.named_account_id = P_NAMED_ACCT_ID); --Delete named account if it has no other TG references
307:
308: l_user_id := fnd_global.user_id;
309: l_login_id := fnd_global.login_id;
310:
311: /* shli GSST Decom */
312: /*--Insert row to track changes for GTP

Line 309: l_login_id := fnd_global.login_id;

305: from JTF_TTY_NAMED_ACCTS a
306: where a.named_account_id = P_NAMED_ACCT_ID); --Delete named account if it has no other TG references
307:
308: l_user_id := fnd_global.user_id;
309: l_login_id := fnd_global.login_id;
310:
311: /* shli GSST Decom */
312: /*--Insert row to track changes for GTP
313: INSERT INTO jtf_tty_named_acct_changes

Line 765: l_user_id := fnd_global.user_id;

761: FETCH c_check_na_exists into l_na_id, l_mapping_flag;
762:
763: --Get site_type_code and user_id needed while creating NA and TGA
764: l_site_type_code := JTF_TTY_MAINTAIN_NA_PVT.get_site_type_code(l_party_id);
765: l_user_id := fnd_global.user_id;
766: l_login_id := fnd_global.login_id;
767:
768: --If named account does not exist, then create a named account for the party
769: IF c_check_na_exists%NOTFOUND THEN

Line 766: l_login_id := fnd_global.login_id;

762:
763: --Get site_type_code and user_id needed while creating NA and TGA
764: l_site_type_code := JTF_TTY_MAINTAIN_NA_PVT.get_site_type_code(l_party_id);
765: l_user_id := fnd_global.user_id;
766: l_login_id := fnd_global.login_id;
767:
768: --If named account does not exist, then create a named account for the party
769: IF c_check_na_exists%NOTFOUND THEN
770:

Line 953: l_user_id := fnd_global.user_id;

949: OPEN c_get_rsc_details(p_terr_grp_id);
950: LOOP
951: FETCH c_get_rsc_details INTO l_rsc_group_id, l_resource_id, l_rsc_role_code, l_rsc_resource_type;
952: EXIT WHEN c_get_rsc_details%NOTFOUND;
953: l_user_id := fnd_global.user_id;
954: INSERT INTO jtf_tty_named_acct_rsc
955: (ACCOUNT_RESOURCE_ID,
956: OBJECT_VERSION_NUMBER,
957: TERR_GROUP_ACCOUNT_ID,

Line 1057: l_user_id := fnd_global.user_id;

1053: BEGIN
1054:
1055: x_status := 'S';
1056: x_return_status := FND_API.G_RET_STS_SUCCESS;
1057: l_user_id := fnd_global.user_id;
1058:
1059: IF (P_RESOURCE_NAME is not null AND P_GROUP_NAME is not null AND P_ROLE_NAME is not null) THEN
1060:
1061: --Validation against LOVs by terr group's owner resource_id allows a resource not owned by the logged in

Line 1615: fnd_global.user_id,

1611: p_owner_group_id,
1612: p_owner_role_code,
1613: 'RS_EMPLOYEE',
1614: 'N',
1615: fnd_global.user_id,
1616: sysdate,
1617: fnd_global.user_id,
1618: sysdate,
1619: null);

Line 1617: fnd_global.user_id,

1613: 'RS_EMPLOYEE',
1614: 'N',
1615: fnd_global.user_id,
1616: sysdate,
1617: fnd_global.user_id,
1618: sysdate,
1619: null);
1620: END;
1621: END LOOP;

Line 1795: l_user := fnd_global.USER_ID;

1791: **** if ASSIGN_SUBSIDIARIES has been selected for any resource
1792: ************************************************************/
1793:
1794:
1795: l_user := fnd_global.USER_ID;
1796: l_login_id := fnd_global.LOGIN_ID;
1797: x_return_status := fnd_api.g_ret_sts_success;
1798:
1799:

Line 1796: l_login_id := fnd_global.LOGIN_ID;

1792: ************************************************************/
1793:
1794:
1795: l_user := fnd_global.USER_ID;
1796: l_login_id := fnd_global.LOGIN_ID;
1797: x_return_status := fnd_api.g_ret_sts_success;
1798:
1799:
1800:

Line 2434: l_user_id := fnd_global.user_id;

2430:
2431: BEGIN
2432:
2433: -- dbms_output.put_line('Sandeep - before update sales team');
2434: l_user_id := fnd_global.user_id;
2435: l_added_rscs_tbl := SALESREP_RSC_TBL_TYPE();
2436: l_added_rscs_tbl := p_added_rscs_tbl;
2437: l_affected_parties_tbl := AFFECTED_PARTY_TBL_TYPE();
2438: l_owners_tbl := OWNER_RSC_TBL_TYPE();

Line 2667: p_user_attribute1 => fnd_global.user_id,

2663: x_msg_data => x_msg_data,
2664: p_from_where => 'ADMIN',
2665: p_user_resource_id => null,
2666: p_terr_group_id => p_terr_gp_id,
2667: p_user_attribute1 => fnd_global.user_id,
2668: --p_user_attribute1 => 1069,
2669: p_user_attribute2 => null,
2670: p_added_rscs_tbl => l_add_rscs_tbl,
2671: p_removed_rscs_tbl => l_removed_rscs_tbl,

Line 2763: l_user_id := fnd_global.user_id;

2759:
2760: BEGIN
2761:
2762: -- dbms_output.put_line('Sandeep - Start of Add sales team');
2763: l_user_id := fnd_global.user_id;
2764: l_added_rscs_tbl := SALESREP_RSC_TBL_TYPE();
2765: l_added_rscs_tbl := p_added_rscs_tbl;
2766: l_affected_parties_tbl := AFFECTED_PARTY_TBL_TYPE();
2767: l_owners_tbl := OWNER_RSC_TBL_TYPE();

Line 2913: p_user_attribute1 => fnd_global.user_id,

2909: x_msg_data => x_msg_data,
2910: p_from_where => 'ADMIN',
2911: p_user_resource_id => null,
2912: p_terr_group_id => p_terr_gp_id,
2913: p_user_attribute1 => fnd_global.user_id,
2914: --p_user_attribute1 => 1069,
2915: p_user_attribute2 => null,
2916: p_added_rscs_tbl => l_add_rscs_tbl,
2917: p_removed_rscs_tbl => l_removed_rscs_tbl,