APPS.PQH_DOCUMENTS_WRAPPER dependencies on PQH_DOCUMENT_ATTRIBUTES_F

Line 26: From pqh_document_attributes_f

22: -- This cursor fetchs all records from child table irrespective of dates
23:
24: Cursor CurRetrieveChildRecord is
25: Select document_attribute_id, object_version_number,effective_start_date
26: From pqh_document_attributes_f
27: Where document_id = p_document_id
28: AND p_effective_date between effective_start_date and effective_end_date;
29:
30: Cursor csr_child_records_for_zap IS

Line 32: From pqh_document_attributes_f daf

28: AND p_effective_date between effective_start_date and effective_end_date;
29:
30: Cursor csr_child_records_for_zap IS
31: Select document_attribute_id, object_version_number,effective_start_date
32: From pqh_document_attributes_f daf
33: Where daf.document_id = p_document_id
34: and rowid = (select min(rowid)
35: From pqh_document_attributes_f
36: Where document_id = p_document_id

Line 35: From pqh_document_attributes_f

31: Select document_attribute_id, object_version_number,effective_start_date
32: From pqh_document_attributes_f daf
33: Where daf.document_id = p_document_id
34: and rowid = (select min(rowid)
35: From pqh_document_attributes_f
36: Where document_id = p_document_id
37: and document_attribute_id = daf.document_attribute_id);
38:
39: --

Line 42: from pqh_document_attributes_f pdaf

38:
39: --
40: Cursor csr_child_attributes IS
41: Select document_attribute_id,effective_start_date
42: from pqh_document_attributes_f pdaf
43: where pdaf.document_id = p_document_id
44: and pdaf.effective_start_date >
45: (
46: select (effective_end_date) from pqh_documents_f pdf where p_effective_date between effective_start_date and effective_end_date

Line 61: from pqh_document_attributes_f

57: Cursor csr_future_eff_child_recs IS
58: Select max(effective_start_date) from
59: (
60: Select effective_start_date
61: from pqh_document_attributes_f
62: where document_id =p_document_id
63: and effective_start_date > p_effective_date
64: and document_attribute_id NOT IN (select document_attribute_id
65: from pqh_document_attributes_f

Line 65: from pqh_document_attributes_f

61: from pqh_document_attributes_f
62: where document_id =p_document_id
63: and effective_start_date > p_effective_date
64: and document_attribute_id NOT IN (select document_attribute_id
65: from pqh_document_attributes_f
66: where document_id =p_document_id
67: and p_effective_date between effective_start_date and effective_end_date)
68: );
69: --

Line 74: From pqh_document_attributes_f

70: Cursor csr_future_end_dt_child_recs IS
71: Select max(effective_end_date)
72: from (
73: Select *
74: From pqh_document_attributes_f
75: Where document_id = p_document_id
76: And p_effective_date between effective_start_date and effective_end_date
77: AND p_effective_date < decode(effective_end_date , hr_general.end_of_time,p_effective_date-1,effective_end_date)
78: );

Line 202: delete from pqh_document_attributes_f where

198:
199: ELSIF ( p_datetrack_mode = 'FUTURE_CHANGE' ) THEN
200: For docAttributeCsr in csr_child_attributes
201: loop
202: delete from pqh_document_attributes_f where
203: document_attribute_id = docAttributeCsr.document_attribute_id
204: and effective_start_date >= docAttributeCsr.effective_start_date;
205: end loop;
206:

Line 234: update pqh_document_attributes_f t

230: IF ( p_datetrack_mode = 'DELETE' ) THEN
231: For docAttributeCursor in CurRetrieveChildRecord
232: loop
233:
234: update pqh_document_attributes_f t
235: set t.effective_end_date = hr_general.end_of_time
236: where t.document_attribute_id = docAttributeCursor.document_attribute_id
237: and effective_end_date = p_effective_date
238: and effective_start_date = docAttributeCursor.effective_start_date;