eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CI_MERGE dependencies on PA_VARCHAR2_150_TBL_TYPE

Line 3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3108: l_bl_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3109: l_bl_CHANGE_REASON_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3110: l_bl_DESCRIPTION_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3111: l_bl_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3109: l_bl_CHANGE_REASON_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3110: l_bl_DESCRIPTION_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3111: l_bl_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3110: l_bl_DESCRIPTION_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3111: l_bl_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3111: l_bl_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3115: l_bl_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3116: l_bl_ATTRIBUTE5_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3117: l_bl_ATTRIBUTE6_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3118: l_bl_ATTRIBUTE7_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3119: l_bl_ATTRIBUTE8_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3120: l_bl_ATTRIBUTE9_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3121: l_bl_ATTRIBUTE10_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3129: l_bl_COST_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3122: l_bl_ATTRIBUTE11_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3129: l_bl_COST_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3130: l_bl_REVENUE_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3123: l_bl_ATTRIBUTE12_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3129: l_bl_COST_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3130: l_bl_REVENUE_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3131: l_bl_BURDEN_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

3124: l_bl_ATTRIBUTE13_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3125: l_bl_ATTRIBUTE14_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3126: l_bl_ATTRIBUTE15_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3127: l_bl_PM_PRODUCT_CODE_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3128: l_bl_PM_BUDGET_LINE_REF_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3129: l_bl_COST_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3130: l_bl_REVENUE_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3131: l_bl_BURDEN_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3132: l_bl_OTHER_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 10368: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type

10364: ,p_ci_rev_version_id_tbl IN SYSTEM.pa_num_tbl_type
10365: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
10366: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
10367: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10368: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10372: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 10382: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895

10378: ,x_ci_rev_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10379: ,x_ci_all_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10380: ,x_budget_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10381: ,x_fin_plan_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10382: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895
10383: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895
10384: ,x_ci_number OUT NOCOPY SYSTEM.pa_varchar2_100_tbl_type --File.Sql.39 bug 4440895
10385: ,x_budget_ci_map_rec_tbl OUT NOCOPY budget_ci_map_rec_tbl_type --File.Sql.39 bug 4440895
10386: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895

Line 10465: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

10461: l_msg_count_at_end NUMBER;
10462:
10463: l_version_type pa_budget_versions.version_type%TYPE;
10464: l_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
10465: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
10466: -- Bug 5845142
10467: l_app_cost_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10468: l_app_rev_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10469: l_app_cost_plan_type_flag VARCHAR2(1);

Line 10656: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();

10652: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10653: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10654: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10655: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
10656: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();
10657: IF p_funding_category IS NULL THEN
10658: x_funding_category := 'ADDITIONAL';
10659: -- Bug 3749322- adding the else clause to pass the value of
10660: -- p_funding_category as it is passed

Line 12540: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type

12536: ,p_ci_cost_version_id_tbl IN SYSTEM.pa_num_tbl_type
12537: ,p_ci_rev_version_id_tbl IN SYSTEM.pa_num_tbl_type
12538: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
12539: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
12540: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
12541: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

Line 12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

12581: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12587: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12588: l_ci_number SYSTEM.pa_varchar2_100_tbl_type :=SYSTEM.pa_varchar2_100_tbl_type();
12589: l_plan_type_collection VARCHAR2(2000);

Line 12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12587: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12588: l_ci_number SYSTEM.pa_varchar2_100_tbl_type :=SYSTEM.pa_varchar2_100_tbl_type();
12589: l_plan_type_collection VARCHAR2(2000);
12590: l_ci_number_collection VARCHAR2(2000);

Line 12587: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12587: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12588: l_ci_number SYSTEM.pa_varchar2_100_tbl_type :=SYSTEM.pa_varchar2_100_tbl_type();
12589: l_plan_type_collection VARCHAR2(2000);
12590: l_ci_number_collection VARCHAR2(2000);
12591: l_partial_impl_succeeded VARCHAR2(1);

Line 12776: l_succ_impl_plan_types := SYSTEM.pa_varchar2_150_tbl_type();

12772: pa_debug.g_err_stage:='Looping for Calling the merge into single version API';
12773: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12774: END IF;
12775: --Initialise the pl/sql tbls.
12776: l_succ_impl_plan_types := SYSTEM.pa_varchar2_150_tbl_type();
12777: l_succ_impl_cos := SYSTEM.pa_varchar2_150_tbl_type();
12778:
12779:
12780: --dbms_output.put_line('M4');

Line 12777: l_succ_impl_cos := SYSTEM.pa_varchar2_150_tbl_type();

12773: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12774: END IF;
12775: --Initialise the pl/sql tbls.
12776: l_succ_impl_plan_types := SYSTEM.pa_varchar2_150_tbl_type();
12777: l_succ_impl_cos := SYSTEM.pa_varchar2_150_tbl_type();
12778:
12779:
12780: --dbms_output.put_line('M4');
12781: --Call the Merge API