DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_RESOURCE_LIST_MEMBERS

Line 767: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

763: l_msg_data VARCHAR2(2000);
764: l_data VARCHAR2(2000);
765: l_msg_index_out NUMBER:=0;
766: l_count NUMBER;
767: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
768: l_uncategorized_flag VARCHAR2(1);
769: BEGIN
770: IF p_pa_debug_mode = 'Y' THEN
771: pa_debug.set_curr_function( p_function => 'CALL_SUMM_POP_TMPS',

Line 3037: FROM pa_resource_list_members

3033: P_RESOURCE_LIST_ID => P_TARGET_RES_LIST_ID,
3034: P_RESOURCE_CLASS_CODE => 'FINANCIAL_ELEMENTS');
3035: /*
3036: SELECT resource_list_member_id INTO l_ppl_class_rlm_id
3037: FROM pa_resource_list_members
3038: WHERE resource_list_id = P_TARGET_RES_LIST_ID
3039: AND resource_class_flag = 'Y'
3040: AND resource_class_code = 'PEOPLE';
3041: */

Line 4191: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,

4187: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4188: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4189: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4190: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4191: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4192: P_ACTUALS_THRU_DATE IN DATE,
4193: X_ACT_QUANTITY OUT NOCOPY NUMBER,
4194: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
4195: X_ACT_TXN_RAW_COST OUT NOCOPY NUMBER,