DBA Data[Home] [Help]

APPS.AS_RTTAP_ACCOUNT dependencies on FND_GLOBAL

Line 874: ACC.last_updated_by = FND_GLOBAL.USER_ID,

870: ---IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
871: UPDATE AS_ACCESSES_ALL ACC
872: SET object_version_number = nvl(object_version_number,0) + 1,
873: ACC.last_update_date = SYSDATE,
874: ACC.last_updated_by = FND_GLOBAL.USER_ID,
875: ACC.last_update_login = FND_GLOBAL.USER_ID,
876: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
877: WHERE ACC.customer_id = G_PARTY_ID
878: AND ACC.lead_id IS NULL

Line 875: ACC.last_update_login = FND_GLOBAL.USER_ID,

871: UPDATE AS_ACCESSES_ALL ACC
872: SET object_version_number = nvl(object_version_number,0) + 1,
873: ACC.last_update_date = SYSDATE,
874: ACC.last_updated_by = FND_GLOBAL.USER_ID,
875: ACC.last_update_login = FND_GLOBAL.USER_ID,
876: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
877: WHERE ACC.customer_id = G_PARTY_ID
878: AND ACC.lead_id IS NULL
879: AND ACC.sales_lead_id IS NULL

Line 952: FND_GLOBAL.USER_ID last_updated_by,

948: created_by_tap_flag,
949: salesforce_role_code
950: FROM
951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,

Line 954: FND_GLOBAL.USER_ID created_by,

950: FROM
951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,
957: 'N' freeze_flag,
958: 'N' reassign_flag,

Line 955: FND_GLOBAL.USER_ID last_update_login,

951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,
957: 'N' freeze_flag,
958: 'N' reassign_flag,
959: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','Y','N') team_leader_flag,

Line 1010: FND_GLOBAL.USER_ID,

1006: partner_customer_id,
1007: partner_cont_party_id,org_id)
1008: SELECT AS_ACCESSES_S.NEXTVAL,
1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',

Line 1012: FND_GLOBAL.USER_ID,

1008: SELECT AS_ACCESSES_S.NEXTVAL,
1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',
1015: 'N',
1016: 'N',

Line 1013: FND_GLOBAL.USER_ID,

1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',
1015: 'N',
1016: 'N',
1017: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','Y','N'),

Line 1084: FND_GLOBAL.USER_ID,

1080: ACC.access_id,
1081: p_WinningTerrMember_tbl.terr_id(l_index),
1082: p_WinningTerrMember_tbl.terr_id(l_index),
1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC

Line 1086: FND_GLOBAL.USER_ID,

1082: p_WinningTerrMember_tbl.terr_id(l_index),
1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC
1089: WHERE ACC.customer_id = G_PARTY_ID
1090: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)

Line 1087: FND_GLOBAL.USER_ID

1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC
1089: WHERE ACC.customer_id = G_PARTY_ID
1090: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1091: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index)

Line 1110: FND_GLOBAL.USER_ID,

1106: SELECT ACC.access_id,
1107: p_WinningTerrMember_tbl.terr_id(l_index),
1108: p_WinningTerrMember_tbl.terr_id(l_index),
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC

Line 1112: FND_GLOBAL.USER_ID,

1108: p_WinningTerrMember_tbl.terr_id(l_index),
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC
1115: WHERE ACC.customer_id = G_PARTY_ID
1116: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)

Line 1113: FND_GLOBAL.USER_ID

1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC
1115: WHERE ACC.customer_id = G_PARTY_ID
1116: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1117: AND NVL(ACC.sales_group_id,-777) = NVL(p_WinningTerrMember_tbl.group_id(l_index),-777)