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.PAY_SLA_UPDATE_PKG dependencies on PAY_PATCH_STATUS

Line 11: -- Name : Trans_Pay_Patch_Status

7: g_xla_event_s xla_events.event_id%type;
8: g_xla_headers_s xla_ae_headers.ae_header_id%type;
9:
10: -------------------------------------------------------------------------------------
11: -- Name : Trans_Pay_Patch_Status
12: -- Function : To transfer qualified periods to PAY_PATCH_STATUS.
13: -- Period should be Closed/Permanently Closed , Non Adjustment
14: -- and between Start Period and End Period both inclusive .
15: --

Line 12: -- Function : To transfer qualified periods to PAY_PATCH_STATUS.

8: g_xla_headers_s xla_ae_headers.ae_header_id%type;
9:
10: -------------------------------------------------------------------------------------
11: -- Name : Trans_Pay_Patch_Status
12: -- Function : To transfer qualified periods to PAY_PATCH_STATUS.
13: -- Period should be Closed/Permanently Closed , Non Adjustment
14: -- and between Start Period and End Period both inclusive .
15: --
16: -- Column Values

Line 18: -- ID = Pay_Patch_Status_s.Nextval

14: -- and between Start Period and End Period both inclusive .
15: --
16: -- Column Values
17: -- ==============
18: -- ID = Pay_Patch_Status_s.Nextval
19: -- Patch Number = Ledger Id
20: -- Patch Name = Period Name
21: -- Process Type = 'PAYSLAUPG'
22: -- Status = Null if period needs to be upgraded by this process.

Line 29: PROCEDURE Trans_Pay_Patch_Status

25: -- To identify what periods are inserted by a particular
26: -- Conc Program
27: -------------------------------------------------------------------------------------
28:
29: PROCEDURE Trans_Pay_Patch_Status
30: (p_Ledger_Id IN VARCHAR2,
31: p_Start_Period IN VARCHAR2,
32: p_End_Period IN VARCHAR2)
33: IS

Line 62: /* Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */

58:
59: lv_temp NUMBER(5);
60:
61: BEGIN
62: /* Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */
63:
64: FOR a IN csr_Get_Periods LOOP
65: lv_temp := NULL;
66:

Line 72: FROM Pay_Patch_Status pps

68: SELECT 1
69: INTO lv_temp
70: FROM Dual
71: WHERE EXISTS (SELECT 1
72: FROM Pay_Patch_Status pps
73: WHERE Process_Type = gv_process_name
74: AND pps.Patch_Number = a.Ledger_Id
75: AND pps.Patch_Name = a.Period_Name
76: AND Status = 'U');

Line 84: INSERT INTO Pay_Patch_Status

80: END;
81: /* If already upgraded thenset status as U else Null */
82:
83: IF lv_temp = 0 THEN
84: INSERT INTO Pay_Patch_Status
85: (Id,
86: Patch_Number,
87: Patch_Name,
88: Process_Type,

Line 92: VALUES (Pay_Patch_Status_s.Nextval,

88: Process_Type,
89: Status,
90: Phase,
91: update_date)
92: VALUES (Pay_Patch_Status_s.Nextval,
93: a.Ledger_Id,
94: a.Period_Name,
95: gv_process_name,
96: NULL,

Line 100: INSERT INTO Pay_Patch_Status

96: NULL,
97: gv_process_name||fnd_Global.Conc_Request_Id,
98: sysdate );
99: ELSIF lv_temp = 1 THEN
100: INSERT INTO Pay_Patch_Status
101: (Id,
102: Patch_Number,
103: Patch_Name,
104: Process_Type,

Line 109: VALUES (Pay_Patch_Status_s.Nextval,

105: Status,
106: Phase,
107: Description,
108: update_date)
109: VALUES (Pay_Patch_Status_s.Nextval,
110: a.Ledger_Id,
111: a.Period_Name,
112: gv_process_name,
113: 'U',

Line 184: Cursor csr_pay_patch_status(p_req_id in number) is

180: lv_Num_Workers number default 1;
181: lv_debug_enabled boolean default FALSE;
182: lv_no_periods boolean default TRUE;
183:
184: Cursor csr_pay_patch_status(p_req_id in number) is
185: select row_number() over(partition by phase order by id) Nu,patch_number Ledger_id,patch_name Period_name,decode(Status,'U','Upgraded','E','Errored',null) Status,Description description
186: from pay_patch_status
187: where PROCESS_TYPE='PAYSLAUPG'
188: and phase='PAYSLAUPG'||to_char(p_req_id)

Line 186: from pay_patch_status

182: lv_no_periods boolean default TRUE;
183:
184: Cursor csr_pay_patch_status(p_req_id in number) is
185: select row_number() over(partition by phase order by id) Nu,patch_number Ledger_id,patch_name Period_name,decode(Status,'U','Upgraded','E','Errored',null) Status,Description description
186: from pay_patch_status
187: where PROCESS_TYPE='PAYSLAUPG'
188: and phase='PAYSLAUPG'||to_char(p_req_id)
189: and patch_number=p_ledger_id
190: order by id;

Line 247: /* Call Trans_pay_patch_status to Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */

243: if ((l_retstatus = TRUE) AND (l_table_owner is not null)) then
244:
245: Begin
246:
247: /* Call Trans_pay_patch_status to Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */
248:
249: If lv_debug_enabled then
250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');
251: End if;

Line 250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');

246:
247: /* Call Trans_pay_patch_status to Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */
248:
249: If lv_debug_enabled then
250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');
251: End if;
252:
253: Trans_pay_patch_status (
254: P_LEDGER_ID => P_LEDGER_ID,

Line 253: Trans_pay_patch_status (

249: If lv_debug_enabled then
250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');
251: End if;
252:
253: Trans_pay_patch_status (
254: P_LEDGER_ID => P_LEDGER_ID,
255: P_START_PERIOD => P_START_PERIOD,
256: P_END_PERIOD => P_END_PERIOD);
257:

Line 259: fnd_file.put_line(fnd_file.log,'After Trans_pay_patch_status ');

255: P_START_PERIOD => P_START_PERIOD,
256: P_END_PERIOD => P_END_PERIOD);
257:
258: If lv_debug_enabled then
259: fnd_file.put_line(fnd_file.log,'After Trans_pay_patch_status ');
260: End if;
261:
262: lv_Num_Workers := X_Num_Workers;
263: /* Get the Pay Action Parameter Value of THREADS */

Line 347: For b in csr_pay_patch_status(fnd_global.conc_request_id)

343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
345:
346:
347: For b in csr_pay_patch_status(fnd_global.conc_request_id)
348: loop
349: fnd_file.put_line(FND_FILE.LOG,' '||substr(rpad(to_char(b.nu),3,' '),1,4)||' '||b.period_name||' '||b.status||' '||b.Description);
350: lv_no_periods := FALSE;
351: end loop;

Line 415: l_table_name varchar2(30) := 'PAY_PATCH_STATUS';

411:
412: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Proc_WKR';
413: l_worker_id number;
414: l_product varchar2(30);
415: l_table_name varchar2(30) := 'PAY_PATCH_STATUS';
416: l_id_column varchar2(30) := 'ID';
417: l_update_name varchar2(30);
418:
419: l_table_owner varchar2(30);

Line 660: Cursor csr_get_periods(p_start_id in pay_patch_status.id%type,

656: lv_Error_msg varchar2(1000);
657: lv_application_name CONSTANT varchar2(10) := 'Payroll';
658: lv_debug_enabled boolean default FALSE;
659:
660: Cursor csr_get_periods(p_start_id in pay_patch_status.id%type,
661: p_end_id in pay_patch_status.id%type,
662: p_process_name in varchar2,
663: p_mgr_req_id in varchar2)
664: is

Line 661: p_end_id in pay_patch_status.id%type,

657: lv_application_name CONSTANT varchar2(10) := 'Payroll';
658: lv_debug_enabled boolean default FALSE;
659:
660: Cursor csr_get_periods(p_start_id in pay_patch_status.id%type,
661: p_end_id in pay_patch_status.id%type,
662: p_process_name in varchar2,
663: p_mgr_req_id in varchar2)
664: is
665: select patch_number ledger_id,patch_name period_name

Line 666: from pay_patch_status

662: p_process_name in varchar2,
663: p_mgr_req_id in varchar2)
664: is
665: select patch_number ledger_id,patch_name period_name
666: from pay_patch_status
667: where id between p_start_id and p_end_id
668: and process_type=p_process_name
669: and phase = p_process_name||p_mgr_req_id
670: and patch_number=p_ledger_id

Line 1118: update pay_patch_status

1114: If lv_debug_enabled then
1115: fnd_file.put_line(fnd_file.log,'After Inserting into XLA Tables ');
1116: End if;
1117:
1118: update pay_patch_status
1119: set status='U',
1120: description='Period Successfully Upgraded'
1121: where process_type=gv_process_name
1122: and phase =gv_process_name||P_MGR_REQ_ID

Line 1138: update pay_patch_status

1134: Rollback;
1135:
1136: lv_Error_msg :=SQLCODE||' '||SQLERRM;
1137:
1138: update pay_patch_status
1139: set status='E',
1140: description='Error '||lv_Error_msg
1141: where process_type=gv_process_name
1142: and phase =gv_process_name||P_MGR_REQ_ID