eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_MAPPING dependencies on PA_RESOURCE_MAPPING

Line 1: PACKAGE BODY PA_RESOURCE_MAPPING AS

1: PACKAGE BODY PA_RESOURCE_MAPPING AS
2: /* $Header: PARSMAPB.pls 120.6 2005/09/08 05:25:46 appldev noship $ */
3:
4: -- Global variables -----------------------------------
5: g_pa_schema VARCHAR2(30);

Line 131: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN

127: IF p_resource_token = 'PER' THEN
128: RETURN ' tab1.PERSON_ID = tab2.PERSON_ID';
129: ELSIF p_resource_token = 'FN1' THEN
130: l_str := '''EXPENDITURE_TYPE'' ';
131: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
132: RETURN ' tab1.EXPENDITURE_TYPE = tab2.EXPENDITURE_TYPE '; --bug#3779049
133: ELSE --bug#4318046
134: RETURN ' tab1.EXPENDITURE_TYPE = tab2.EXPENDITURE_TYPE AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE '; --bug#3779049
135: END IF;

Line 138: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN

134: RETURN ' tab1.EXPENDITURE_TYPE = tab2.EXPENDITURE_TYPE AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE '; --bug#3779049
135: END IF;
136: ELSIF p_resource_token = 'FN2' THEN
137: l_str := '''EVENT_TYPE'' ';
138: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
139: RETURN ' tab1.EVENT_TYPE = tab2.EVENT_TYPE '; --bug#3779049
140: ELSE --bug#4318046
141: RETURN ' tab1.EVENT_TYPE = tab2.EVENT_TYPE AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE '; --bug#3779049
142: END IF;

Line 145: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN

141: RETURN ' tab1.EVENT_TYPE = tab2.EVENT_TYPE AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE '; --bug#3779049
142: END IF;
143: ELSIF p_resource_token = 'FN3' THEN
144: l_str := '''EXPENDITURE_CATEGORY'' ';
145: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
146: RETURN ' tab1.EXPENDITURE_CATEGORY = tab2.EXPENDITURE_CATEGORY '; --bug#3779049
147: ELSE --bug#4318046
148: RETURN ' tab1.EXPENDITURE_CATEGORY = tab2.EXPENDITURE_CATEGORY AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE ';
149: END IF;

Line 152: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN

148: RETURN ' tab1.EXPENDITURE_CATEGORY = tab2.EXPENDITURE_CATEGORY AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE ';
149: END IF;
150: ELSIF p_resource_token = 'FN4' THEN
151: l_str := '''REVENUE_CATEGORY'' ';
152: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
153: RETURN ' tab1.REVENUE_CATEGORY = tab2.REVENUE_CATEGORY '; --bug#3779049
154: ELSE --bug#4318046
155:
156: RETURN ' tab1.REVENUE_CATEGORY = tab2.REVENUE_CATEGORY AND tab1.FC_RES_TYPE_CODE = ' || l_str || ' and tab1.FC_RES_TYPE_CODE = tab2.FC_RES_TYPE_CODE '; --bug#3779049

Line 1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_MAPPING'

1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: x_msg_data :=SQLERRM();
1237:
1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_MAPPING'
1239: , p_procedure_name => 'MAP_RESOURCE_LIST');
1240:
1241: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1242:

Line 1283: END; --end package pa_resource_mapping

1279: END LOOP;
1280:
1281: END;
1282:
1283: END; --end package pa_resource_mapping