APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_REENTRANT_PROCESS_STATUS

Line 6380: from psb_reentrant_process_status

6376: nvl(to_number(attribute26),0),
6377: nvl(to_number(attribute27),0),
6378: nvl(to_number(attribute28),0),
6379: nvl(to_number(attribute29),0)
6380: from psb_reentrant_process_status
6381: where process_type = 'HR DATA EXTRACT'
6382: and process_uid = p_data_extract_id;
6383:
6384: l_api_name CONSTANT VARCHAR2(30) := 'Check_Reentry';

Line 6621: from psb_reentrant_process_status

6617: IS
6618:
6619: Cursor C_Reenter_Upd is
6620: Select rowid
6621: from psb_reentrant_process_status
6622: where process_type = 'HR DATA EXTRACT'
6623: and process_uid = p_data_extract_id;
6624:
6625: -- Commenting this condition as part of DE by Org, since

Line 6726: Insert Into Psb_Reentrant_Process_Status

6722:
6723: Fetch C_Reenter_Upd into l_rowid;
6724:
6725: if C_Reenter_Upd%NOTFOUND then
6726: Insert Into Psb_Reentrant_Process_Status
6727: (process_type,
6728: process_uid,
6729: attribute1,
6730: attribute11,

Line 6773: Update Psb_Reentrant_Process_Status

6769: l_attribute27,
6770: l_attribute28,
6771: l_attribute29);
6772: else
6773: Update Psb_Reentrant_Process_Status
6774: set attribute11 = decode(p_process,'Positions Interface',l_attribute11,attribute11),
6775: attribute12 = decode(p_process,'Salary Interface',l_attribute12,attribute12),
6776: attribute13 = decode(p_process,'Employees Interface',l_attribute13,attribute13),
6777: attribute14 = decode(p_process,'Costing Interface',l_attribute14,attribute14),

Line 6862: from psb_reentrant_process_status

6858: nvl(sp19_status,'I'),
6859: attribute1,
6860: attribute2,
6861: nvl(to_number(attribute3),0)
6862: from psb_reentrant_process_status
6863: where process_type = 'HR DATA EXTRACT'
6864: and process_uid = p_data_extract_id;
6865:
6866: -- Commenting this condition as part of DE by Org, since

Line 6996: Insert Into Psb_Reentrant_Process_Status

6992: l_refresh_num := l_attribute3 + 1;
6993: end if;
6994:
6995: if C_Reentrant%NOTFOUND then
6996: Insert Into Psb_Reentrant_Process_Status
6997: (process_type,
6998: process_uid,
6999: sp1_status,
7000: sp2_status,

Line 7049: Update Psb_Reentrant_Process_Status

7045: l_last_update_date,
7046: to_char(l_refresh_num)
7047: );
7048: else
7049: Update Psb_Reentrant_Process_Status
7050: set sp1_status = decode(p_process,'Positions Interface','C',sp1_status),
7051: sp2_status = decode(p_process,'Salary Interface','C',sp2_status),
7052: sp3_status = decode(p_process,'Employees Interface','C',sp3_status),
7053: sp4_status = decode(p_process,'Costing Interface','C',sp4_status),