DBA Data[Home] [Help]

APPS.OZF_DEBUG_PVT dependencies on MO_GLOB_ORG_ACCESS_TMP

Line 23: CURSOR c_populate_orgs IS SELECT ORGANIZATION_ID,ORGANIZATION_NAME from MO_GLOB_ORG_ACCESS_TMP;

19: IS
20: l_org_id NUMBER;
21: l_org_name VARCHAR2(1000);
22: l_tmp_str VARCHAR2(4000);
23: CURSOR c_populate_orgs IS SELECT ORGANIZATION_ID,ORGANIZATION_NAME from MO_GLOB_ORG_ACCESS_TMP;
24: BEGIN
25: P_APP_SHORT_NAME :=FND_GLOBAL.APPLICATION_SHORT_NAME;
26: P_RESP_ID := FND_GLOBAL.RESP_ID;
27: P_USER_ID := FND_GLOBAL.USER_ID;

Line 58: CURSOR c_populate_orgs IS SELECT ORGANIZATION_ID,ORGANIZATION_NAME from MO_GLOB_ORG_ACCESS_TMP;

54: IS
55: l_org_id NUMBER;
56: l_org_name VARCHAR2(1000);
57: l_tmp_str VARCHAR2(4000);
58: CURSOR c_populate_orgs IS SELECT ORGANIZATION_ID,ORGANIZATION_NAME from MO_GLOB_ORG_ACCESS_TMP;
59: BEGIN
60:
61: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF',P_TEXT||' APP_SHORT_NAME : '||FND_GLOBAL.APPLICATION_SHORT_NAME);
62: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF',P_TEXT||' USER_ID : '||FND_GLOBAL.USER_ID);