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.21.12020000.3 2013/05/27 06:54:21 bpottipa ship $ */
3:
4: -- Global variables -----------------------------------
5: g_pa_schema VARCHAR2(30);

Line 29: g_module_name VARCHAR2(100) := 'pa.plsql.PA_RESOURCE_MAPPING';

25: g_resource_class_flag VARCHAR2(1); -- cbs change
26: g_res_prec_id NUMBER; -- cbs change
27:
28: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
29: g_module_name VARCHAR2(100) := 'pa.plsql.PA_RESOURCE_MAPPING';
30:
31: ---------------------------------
32: --Gets the Projects Schema name
33: ---------------------------------

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

140: IF p_resource_token = 'PER' THEN
141: RETURN ' tab1.PERSON_ID = tab2.PERSON_ID';
142: ELSIF p_resource_token = 'FN1' THEN
143: l_str := '''EXPENDITURE_TYPE'' ';
144: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
145: RETURN ' tab1.EXPENDITURE_TYPE = tab2.EXPENDITURE_TYPE '; --bug#3779049
146: ELSE --bug#4318046
147: 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
148: END IF;

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

147: 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
148: END IF;
149: ELSIF p_resource_token = 'FN2' THEN
150: l_str := '''EVENT_TYPE'' ';
151: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
152: RETURN ' tab1.EVENT_TYPE = tab2.EVENT_TYPE '; --bug#3779049
153: ELSE --bug#4318046
154: 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
155: END IF;

Line 158: IF (Pa_Resource_Mapping.g_called_process ='ACTUALS' or Pa_Resource_Mapping.g_called_process ='COMMITMENTS') THEN -- Bug 9753875

154: 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
155: END IF;
156: ELSIF p_resource_token = 'FN3' THEN
157: l_str := '''EXPENDITURE_CATEGORY'' ';
158: IF (Pa_Resource_Mapping.g_called_process ='ACTUALS' or Pa_Resource_Mapping.g_called_process ='COMMITMENTS') THEN -- Bug 9753875
159: RETURN ' tab1.EXPENDITURE_CATEGORY = tab2.EXPENDITURE_CATEGORY '; --bug#3779049
160: ELSE --bug#4318046
161: 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 ';
162: END IF;

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

161: 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 ';
162: END IF;
163: ELSIF p_resource_token = 'FN4' THEN
164: l_str := '''REVENUE_CATEGORY'' ';
165: IF Pa_Resource_Mapping.g_called_process ='ACTUALS' THEN
166: RETURN ' tab1.REVENUE_CATEGORY = tab2.REVENUE_CATEGORY '; --bug#3779049
167: ELSE --bug#4318046
168:
169: 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 1498: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_MAPPING'

1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: x_msg_data :=SQLERRM();
1497:
1498: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_MAPPING'
1499: , p_procedure_name => 'MAP_RESOURCE_LIST');
1500:
1501: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1502:

Line 1543: END; --end package pa_resource_mapping

1539: END LOOP;
1540:
1541: END;
1542:
1543: END; --end package pa_resource_mapping