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_UTILS2 dependencies on PA_PLSQL_DATATYPES

Line 1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1119: RAISE ;
1120: END get_recvr_pa_date ;
1121: -----------------------------------------------------------------------
1122: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

Line 1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1120: END get_recvr_pa_date ;
1121: -----------------------------------------------------------------------
1122: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,

Line 1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,

1121: -----------------------------------------------------------------------
1122: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1129: p_sys_linkage_type IN VARCHAR2

Line 1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1122: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1129: p_sys_linkage_type IN VARCHAR2
1130: )

Line 1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1123: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1129: p_sys_linkage_type IN VARCHAR2
1130: )
1131:

Line 1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,

1124: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1125: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1126: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1127: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1128: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1129: p_sys_linkage_type IN VARCHAR2
1130: )
1131:
1132: IS

Line 1133: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;

1129: p_sys_linkage_type IN VARCHAR2
1130: )
1131:
1132: IS
1133: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1134: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);

Line 1134: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;

1130: )
1131:
1132: IS
1133: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1134: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);
1138:

Line 1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;

1131:
1132: IS
1133: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1134: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);
1138:
1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;

Line 1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;

1132: IS
1133: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1134: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);
1138:
1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;

Line 1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;

1135: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);
1138:
1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1142:
1143: /** Bug 3668005 Begins **/

Line 1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;

1136: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1137: l_reject_meaning VARCHAR2(81);
1138:
1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1142:
1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

Line 1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;

1137: l_reject_meaning VARCHAR2(81);
1138:
1139: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1142:
1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

Line 1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

1140: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1142:
1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1146: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1147: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1148: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

Line 1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

1141: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1142:
1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1146: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1147: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1148: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1149: l_err_code NUMBER ;

Line 1146: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

1142:
1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1146: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1147: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1148: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1149: l_err_code NUMBER ;
1150: l_err_stage VARCHAR2(2000);

Line 1147: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

1143: /** Bug 3668005 Begins **/
1144: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1145: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1146: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1147: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1148: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1149: l_err_code NUMBER ;
1150: l_err_stage VARCHAR2(2000);
1151: l_err_stack VARCHAR2(255) ;

Line 1155: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;

1151: l_err_stack VARCHAR2(255) ;
1152: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1153: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1154: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1155: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1156:
1157: -- Bug 4374769 : The following variables are introduced as part of this bug.
1158: v_gl_per_end_dt DATE;
1159: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;