APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_DEL_STATUS_HISTORY

Line 31: * okc_del_status_history table, if not, creates a new status history

27: ---------------------------------------------------------------------------
28:
29: /**
30: * This helper procedure check for status history record already in
31: * okc_del_status_history table, if not, creates a new status history
32: * record for given Status.
33: */
34: PROCEDURE checkAndCreateStatusHistory (
35: p_deliverable_id IN NUMBER,

Line 50: FROM okc_del_status_history

46: l_del_row_count := 0;
47:
48: -- check for existing status history record
49: SELECT count(*) into l_del_row_count
50: FROM okc_del_status_history
51: WHERE deliverable_id = p_deliverable_id
52: AND deliverable_status = p_deliverable_status;
53:
54: IF l_del_row_count = 0 THEN

Line 3886: from okc_del_status_history status_history_inner

3882: business_document_type = p_bus_doc_type and
3883: business_document_version = p_bus_doc_version and
3884: deliverable.deliverable_status <>
3885: (select status_history_inner.deliverable_status
3886: from okc_del_status_history status_history_inner
3887: where status_history_inner.deliverable_id = deliverable.deliverable_id
3888: and status_history_inner.deliverable_status <> 'INACTIVE'
3889: and status_history_inner.status_change_date = (select max(status_change_date)
3890: from okc_del_status_history

Line 3890: from okc_del_status_history

3886: from okc_del_status_history status_history_inner
3887: where status_history_inner.deliverable_id = deliverable.deliverable_id
3888: and status_history_inner.deliverable_status <> 'INACTIVE'
3889: and status_history_inner.status_change_date = (select max(status_change_date)
3890: from okc_del_status_history
3891: where deliverable_id = deliverable.deliverable_id and
3892: deliverable_status <> 'INACTIVE'));
3893:
3894:

Line 3906: okc_del_status_history status_history

3902: deliverable.deliverable_id,
3903: status_history.status_change_date
3904: from
3905: okc_deliverables deliverable,
3906: okc_del_status_history status_history
3907: where
3908: deliverable.deliverable_status <> 'INACTIVE' and
3909: business_document_id = p_bus_doc_id and
3910: business_document_type = p_bus_doc_type and

Line 3916: from okc_del_status_history status_history_inner

3912: status_history.deliverable_status = deliverable.deliverable_status and
3913: status_history.deliverable_id = deliverable.deliverable_id and
3914: (deliverable.status_change_notes <> status_history.status_change_notes OR status_history.status_change_notes IS NULL) and
3915: status_history.status_change_date = (select max(status_history_inner.status_change_date)
3916: from okc_del_status_history status_history_inner
3917: where status_history_inner.deliverable_id = deliverable.deliverable_id and status_history_inner.deliverable_status <> 'INACTIVE');
3918: status_notes_rec status_notes_cur%ROWTYPE;
3919:
3920: BEGIN

Line 3942: update okc_del_status_history

3938: END IF;
3939:
3940: --loop thru deliverables where only the notes have changed
3941: FOR status_notes_rec IN status_notes_cur LOOP
3942: update okc_del_status_history
3943: set status_change_notes = status_notes_rec.status_change_notes
3944: where status_change_date = status_notes_rec.status_change_date and
3945: deliverable_id = status_notes_rec.deliverable_id and
3946: deliverable_status = status_notes_rec.deliverable_status;