DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_PLSQL_DATATYPES

Line 15: TempIDTab PA_PLSQL_DATATYPES.IDTabTyp ;

11: /* CBGA
12: * The following variable TempTab is defined - to be used as a default value
13: * for the table parameter expnd_id.
14: */
15: TempIDTab PA_PLSQL_DATATYPES.IDTabTyp ;
16: TempRowIDTab PA_PLSQL_DATATYPES.Char30TabTyp ;
17: /**CBGA**/
18:
19: /**Global variables related to pa_date and recvr_pa_date caching **/

Line 16: TempRowIDTab PA_PLSQL_DATATYPES.Char30TabTyp ;

12: * The following variable TempTab is defined - to be used as a default value
13: * for the table parameter expnd_id.
14: */
15: TempIDTab PA_PLSQL_DATATYPES.IDTabTyp ;
16: TempRowIDTab PA_PLSQL_DATATYPES.Char30TabTyp ;
17: /**CBGA**/
18:
19: /**Global variables related to pa_date and recvr_pa_date caching **/
20: /*

Line 294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,

290: -- This procedure is called by interface programs.
291: ---------------------------------------------------------------
292:
293: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

Line 295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,

291: ---------------------------------------------------------------
292:
293: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,

Line 296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,

292:
293: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,
300: p_sys_linkage_type IN VARCHAR2 DEFAULT NULL

Line 297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

293: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,
300: p_sys_linkage_type IN VARCHAR2 DEFAULT NULL
301: );

Line 298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

294: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,
300: p_sys_linkage_type IN VARCHAR2 DEFAULT NULL
301: );
302:

Line 299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,

295: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
296: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp DEFAULT TempRowIDTab,
297: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
298: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
299: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp DEFAULT TempIDTab,
300: p_sys_linkage_type IN VARCHAR2 DEFAULT NULL
301: );
302:
303: ---------------------------------------------------------------

Line 486: G_CapCostTypProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

482: -----------------------------------------------------------------------
483: FUNCTION get_capital_cost_type_code( p_project_id IN pa_projects_all.project_id%TYPE)
484: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE;
485:
486: G_CapCostTypProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
487: -----------------------------------------------------------------------
488: g_project_id NUMBER;
489: g_project_type pa_projects_all.project_type%type;
490: g_proj_org_id pa_projects_all.org_id%type;

Line 498: G_BdMethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

494: --End Bug 3069632
495:
496: Function Get_Burden_Amt_Display_Method(P_Project_Id in Number) Return Varchar2;
497:
498: G_BdMethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
499:
500: /*S.N. Bug4746949 */
501: Function Proj_Type_Burden_Disp_Method(P_Project_Id in Number) Return Varchar2;
502: G_Bd_MethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 502: G_Bd_MethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

498: G_BdMethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
499:
500: /*S.N. Bug4746949 */
501: Function Proj_Type_Burden_Disp_Method(P_Project_Id in Number) Return Varchar2;
502: G_Bd_MethodProjID_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
503: /*E.N. Bug4746949 */
504:
505: G_PREV_ORG_ID NUMBER(15);
506: G_PREV_TXN_DATE DATE;