DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 212: Function Decode_VARS(p_Buffer VARCHAR2) RETURN SYSTEM.pa_varchar2_240_tbl_type

208: ** in type num and varchar.
209: ** ----------------------------------------------------------
210: */
211:
212: Function Decode_VARS(p_Buffer VARCHAR2) RETURN SYSTEM.pa_varchar2_240_tbl_type
213: AS
214: l_Buffer VARCHAR2(150);
215: i NUMBER:=1;
216: j NUMBER:=0;

Line 218: l_Dim_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

214: l_Buffer VARCHAR2(150);
215: i NUMBER:=1;
216: j NUMBER:=0;
217: k NUMBER:=1;
218: l_Dim_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
219: BEGIN
220: IF p_PA_DEBUG_MODE = 'Y' THEN
221: Write2FWKLog('Entering Decode_VARS...','Decode_VARS');
222: END IF;

Line 584: l_RCate_Dimension_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

580: Function Convert_Event_Revenue_Type(p_Revenue_Category VARCHAR2 DEFAULT NULL
581: , p_Revenue_Type_IDS VARCHAR2 DEFAULT NULL
582: , p_View_BY VARCHAR2) RETURN VARCHAR2
583: AS
584: l_RCate_Dimension_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
585: l_RType_Dimension_List_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
586: l_RC_Parsed_Flag VARCHAR2(1);
587: l_RT_Parsed_Flag VARCHAR2(1):='N';
588: BEGIN

Line 757: l_ECate_Dimension_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

753: Function Convert_Expenditure_Type(p_Expenditure_Category VARCHAR2 DEFAULT NULL
754: , p_Expenditure_Type_IDS VARCHAR2 DEFAULT NULL
755: , p_View_BY VARCHAR2) RETURN VARCHAR2
756: AS
757: l_ECate_Dimension_List_Tab SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
758: l_EType_Dimension_List_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
759: l_EC_Parsed_Flag VARCHAR2(1);
760: l_ET_Parsed_Flag VARCHAR2(1):='N';
761: BEGIN