DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_PROJECT_TYPES_ALL

Line 121: G_project_type_class PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;

117: G_prev_ORIG_TRAN_REF PA_TRANSACTION_INTERFACE_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
118: G_WIP_RESOURCE_ID PA_TRANSACTION_INTERFACE_ALL.WIP_RESOURCE_ID%TYPE;
119:
120:
121: G_project_type_class PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;
122: /* added for the bug# 1428216, starts here */
123: G_burden_amt_display_method PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;
124: /* added for the bug# 1428216, ends here */
125: -- End SST Changes

Line 123: G_burden_amt_display_method PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;

119:
120:
121: G_project_type_class PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;
122: /* added for the bug# 1428216, starts here */
123: G_burden_amt_display_method PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;
124: /* added for the bug# 1428216, ends here */
125: -- End SST Changes
126:
127: -- IC Changes

Line 189: G_PrjInfoTypeClass PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;

185:
186: G_MOrg VARCHAR2(1);
187: G_PrjInfoPrjId NUMBER;
188: G_PrjInfoBCostFlag VARCHAR2(1);
189: G_PrjInfoTypeClass PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;
190: G_PrjInfoBdDisplay PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;
191: G_PrjInfoTotBdFlag PA_PROJECT_TYPES_ALL.TOTAL_BURDEN_FLAG%TYPE;
192: G_NewTxnPrjId NUMBER;
193: --G_NewTxnsAllowed VARCHAR2(1);

Line 190: G_PrjInfoBdDisplay PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;

186: G_MOrg VARCHAR2(1);
187: G_PrjInfoPrjId NUMBER;
188: G_PrjInfoBCostFlag VARCHAR2(1);
189: G_PrjInfoTypeClass PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;
190: G_PrjInfoBdDisplay PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;
191: G_PrjInfoTotBdFlag PA_PROJECT_TYPES_ALL.TOTAL_BURDEN_FLAG%TYPE;
192: G_NewTxnPrjId NUMBER;
193: --G_NewTxnsAllowed VARCHAR2(1);
194: G_EClassInfoEtype VARCHAR2(30);

Line 191: G_PrjInfoTotBdFlag PA_PROJECT_TYPES_ALL.TOTAL_BURDEN_FLAG%TYPE;

187: G_PrjInfoPrjId NUMBER;
188: G_PrjInfoBCostFlag VARCHAR2(1);
189: G_PrjInfoTypeClass PA_PROJECT_TYPES_ALL.PROJECT_TYPE_CLASS_CODE%TYPE;
190: G_PrjInfoBdDisplay PA_PROJECT_TYPES_ALL.BURDEN_AMT_DISPLAY_METHOD%TYPE;
191: G_PrjInfoTotBdFlag PA_PROJECT_TYPES_ALL.TOTAL_BURDEN_FLAG%TYPE;
192: G_NewTxnPrjId NUMBER;
193: --G_NewTxnsAllowed VARCHAR2(1);
194: G_EClassInfoEtype VARCHAR2(30);
195: /* bug #3134359 changed the size of G_EClassInfoSysLink to 30 from 3

Line 1099: pa_project_types_all ptype

1095: total_burden_flag
1096: INTO X_proj_bcost_flag, X_proj_type_class, X_burden_amt_display_method,
1097: X_Total_Burden_Flag
1098: FROM pa_projects_all proj,
1099: pa_project_types_all ptype
1100: WHERE proj.project_type = ptype.project_type
1101: -- MOAC Changes
1102: AND proj.org_id = ptype.org_id
1103: AND project_id = X_Project_id ;