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 3014: FROM pa_resource_list_members

3010: P_RESOURCE_LIST_ID => P_TARGET_RES_LIST_ID,
3011: P_RESOURCE_CLASS_CODE => 'FINANCIAL_ELEMENTS');
3012: /*
3013: SELECT resource_list_member_id INTO l_ppl_class_rlm_id
3014: FROM pa_resource_list_members
3015: WHERE resource_list_id = P_TARGET_RES_LIST_ID
3016: AND resource_class_flag = 'Y'
3017: AND resource_class_code = 'PEOPLE';
3018: */

Line 4167: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,

4163: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4164: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4165: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4166: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4167: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4168: P_ACTUALS_THRU_DATE IN DATE,
4169: X_ACT_QUANTITY OUT NOCOPY NUMBER,
4170: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
4171: X_ACT_TXN_RAW_COST OUT NOCOPY NUMBER,