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 1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1103: RAISE ;
1104: END get_recvr_pa_date ;
1105: -----------------------------------------------------------------------
1106: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

Line 1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1104: END get_recvr_pa_date ;
1105: -----------------------------------------------------------------------
1106: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,

Line 1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,

1105: -----------------------------------------------------------------------
1106: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1113: p_sys_linkage_type IN VARCHAR2

Line 1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1106: PROCEDURE populate_gl_dates( p_local_set_size IN NUMBER,
1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1113: p_sys_linkage_type IN VARCHAR2
1114: )

Line 1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,

1107: p_application_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1113: p_sys_linkage_type IN VARCHAR2
1114: )
1115:

Line 1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,

1108: p_request_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1109: p_cdl_rowid IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1110: p_prvdr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1111: p_recvr_sob_id IN PA_PLSQL_DATATYPES.IDTabTyp,
1112: p_expnd_id IN PA_PLSQL_DATATYPES.IDTabTyp ,
1113: p_sys_linkage_type IN VARCHAR2
1114: )
1115:
1116: IS

Line 1117: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;

1113: p_sys_linkage_type IN VARCHAR2
1114: )
1115:
1116: IS
1117: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1118: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);

Line 1118: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;

1114: )
1115:
1116: IS
1117: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1118: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);
1122:

Line 1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;

1115:
1116: IS
1117: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1118: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);
1122:
1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;

Line 1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;

1116: IS
1117: l_prvdr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1118: l_recvr_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp ;
1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);
1122:
1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;

Line 1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;

1119: l_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);
1122:
1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1126:
1127: /** Bug 3668005 Begins **/

Line 1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;

1120: l_recvr_pa_date PA_PLSQL_DATATYPES.DateTabTyp ;
1121: l_reject_meaning VARCHAR2(81);
1122:
1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1126:
1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

Line 1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;

1121: l_reject_meaning VARCHAR2(81);
1122:
1123: l_gl_date_old PA_PLSQL_DATATYPES.DateTabTyp ;
1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1126:
1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

Line 1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

1124: l_gl_period_old PA_PLSQL_DATATYPES.Char15TabTyp ;
1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1126:
1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1130: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1131: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1132: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

Line 1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

1125: l_recvr_org_id PA_PLSQL_DATATYPES.IDTabTyp ;
1126:
1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1130: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1131: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1132: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1133: l_err_code NUMBER ;

Line 1130: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;

1126:
1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1130: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1131: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1132: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1133: l_err_code NUMBER ;
1134: l_err_stage VARCHAR2(2000);

Line 1131: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;

1127: /** Bug 3668005 Begins **/
1128: l_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1129: l_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1130: l_recvr_gl_date_new PA_PLSQL_DATATYPES.DateTabTyp ;
1131: l_recvr_gl_period_new PA_PLSQL_DATATYPES.Char15TabTyp ;
1132: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1133: l_err_code NUMBER ;
1134: l_err_stage VARCHAR2(2000);
1135: l_err_stack VARCHAR2(255) ;

Line 1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;

1135: l_err_stack VARCHAR2(255) ;
1136: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1137: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1138: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1140:
1141: -- Bug 4374769 : The following variables are introduced as part of this bug.
1142: v_gl_per_end_dt DATE;
1143: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;