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.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_DELIVERABLES

Line 13: G_ENTITY_NAME CONSTANT VARCHAR2(40) := 'OKC_DELIVERABLES';

9: ---------------------------------------------------------------------------
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_MANAGE_DELIVERABLES_GRP';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
13: G_ENTITY_NAME CONSTANT VARCHAR2(40) := 'OKC_DELIVERABLES';
14:
15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------

Line 147: l_del_status OKC_DELIVERABLES.deliverable_status%TYPE;

143: p_del_id IN NUMBER)
144: return VARCHAR2
145: IS
146: l_api_name CONSTANT VARCHAR2(50) := 'checkStatusOfExistingInstances';
147: l_del_status OKC_DELIVERABLES.deliverable_status%TYPE;
148: BEGIN
149:
150: -- initialize
151: l_del_status := null;

Line 162: FROM okc_deliverables

158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'104: del id '||p_del_id);
159: END IF;
160:
161: SELECT deliverable_status into l_del_status
162: FROM okc_deliverables
163: WHERE business_document_id = p_bus_doc_id
164: AND business_document_type = p_bus_doc_type
165: AND business_document_version = p_bus_doc_version
166: AND recurring_del_parent_id = p_del_id

Line 207: FROM okc_deliverables

203: BEGIN
204: -- initialize
205: l_del_row_count := 0;
206: SELECT count(*) into l_del_row_count
207: FROM okc_deliverables
208: WHERE business_document_id = p_bus_doc_id
209: AND business_document_type = p_bus_doc_type
210: AND business_document_version = p_bus_doc_version
211: AND recurring_del_parent_id = p_del_id;

Line 231: delRecord okc_deliverables%ROWTYPE,

227: p_recurr_end_date IN DATE,
228: p_repeat_duration IN NUMBER,
229: p_repeat_day_of_month IN NUMBER,
230: p_repeat_day_of_week IN NUMBER,
231: delRecord okc_deliverables%ROWTYPE,
232: p_change_status_to IN VARCHAR2)
233: IS
234:
235: --- for recurring dates

Line 433: INSERT INTO okc_deliverables

429: --- actual due date
430: IF delInstanceRecTab.count > 0 THEN
431:
432: FOR i IN delInstanceRecTab.FIRST..delInstanceRecTab.LAST LOOP
433: INSERT INTO okc_deliverables
434: (DELIVERABLE_ID,
435: BUSINESS_DOCUMENT_TYPE ,
436: BUSINESS_DOCUMENT_ID ,
437: BUSINESS_DOCUMENT_NUMBER ,

Line 703: * event id, stored in OKC_DELIVERABLES

699: END;
700:
701: /**
702: * Helper method to return Event Code and Before After value for given
703: * event id, stored in OKC_DELIVERABLES
704: */
705: PROCEDURE getDelEventDetails(
706: p_event_id IN NUMBER,
707: p_end_event_yn IN varchar2,

Line 1055: * Resolve deliverable due date, recurring instances to OKC_DELIVERABLES

1051: return l_actual_date;
1052: END;
1053:
1054: /**
1055: * Resolve deliverable due date, recurring instances to OKC_DELIVERABLES
1056: */
1057: PROCEDURE resolveDeliverables (
1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2,

Line 1079: FROM okc_deliverables del

1075: l_api_name CONSTANT VARCHAR2(30) := 'resolveDeliverables';
1076: -- update cursor for bug#4069955
1077: CURSOR del_cur IS
1078: SELECT *
1079: FROM okc_deliverables del
1080: WHERE del.business_document_id = p_bus_doc_id
1081: AND del.business_document_version = p_bus_doc_version
1082: AND del.business_document_type = p_bus_doc_type
1083: AND del.deliverable_status = 'INACTIVE'

Line 1103: SELECT deliverable_id FROM OKC_DELIVERABLES

1099: );
1100: del_rec del_cur%ROWTYPE;
1101:
1102: CURSOR get_del_ids_cur (p_del_id IN NUMBER, p_actual_date IN DATE) IS
1103: SELECT deliverable_id FROM OKC_DELIVERABLES
1104: WHERE business_document_id = p_bus_doc_id
1105: AND business_document_type = p_bus_doc_type
1106: AND business_document_version = p_bus_doc_version
1107: AND recurring_del_parent_id = p_del_id

Line 1114: SELECT deliverable_id FROM OKC_DELIVERABLES

1110: -- this cursor has been introduced to fix bug 3574466. The cursor
1111: -- collectes deliverable_id's of all the instances for given recurring
1112: -- deliverable
1113: CURSOR get_del_ids_cur2 (p_del_id IN NUMBER) IS
1114: SELECT deliverable_id FROM OKC_DELIVERABLES
1115: WHERE business_document_id = p_bus_doc_id
1116: AND business_document_type = p_bus_doc_type
1117: AND business_document_version = p_bus_doc_version
1118: AND recurring_del_parent_id = p_del_id;

Line 1151: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;

1147: l_repeat_day_of_week number;
1148:
1149: l_has_instances_yn VARCHAR2(1);
1150:
1151: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
1152:
1153: --- for deliverable ids
1154: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
1155:

Line 1835: UPDATE okc_deliverables

1831:
1832: --- bulk update for deliverables actual due date
1833: IF deliverableIds.count > 0 THEN
1834: FORALL i IN deliverableIds.FIRST..deliverableIds.LAST
1835: UPDATE okc_deliverables
1836: SET
1837: actual_due_date = deliverableDueDates(i),
1838: start_event_date = deliverableStartEventDates(i),
1839: end_event_date = deliverableEndEventDates(i),

Line 1931: FROM okc_deliverables del

1927: -- update cursor for bug#4069955
1928: -- Updated the cusror bug 5018624
1929: CURSOR del_cur IS
1930: SELECT *
1931: FROM okc_deliverables del
1932: WHERE business_document_id = p_bus_doc_id
1933: AND business_document_type = p_bus_doc_type
1934: AND business_document_version = p_bus_doc_version
1935: AND (

Line 1955: SELECT deliverable_id FROM OKC_DELIVERABLES

1951: );
1952: del_rec del_cur%ROWTYPE;
1953: k PLS_INTEGER;
1954: CURSOR get_del_ids_cur1 (p_del_id IN NUMBER) IS
1955: SELECT deliverable_id FROM OKC_DELIVERABLES
1956: WHERE business_document_id = p_bus_doc_id
1957: AND business_document_type = p_bus_doc_type
1958: AND business_document_version = p_bus_doc_version
1959: AND recurring_del_parent_id = p_del_id;

Line 1962: SELECT deliverable_id FROM OKC_DELIVERABLES

1958: AND business_document_version = p_bus_doc_version
1959: AND recurring_del_parent_id = p_del_id;
1960:
1961: CURSOR get_del_ids_cur2 (p_del_id IN NUMBER, p_actual_date IN DATE) IS
1962: SELECT deliverable_id FROM OKC_DELIVERABLES
1963: WHERE business_document_id = p_bus_doc_id
1964: AND business_document_type = p_bus_doc_type
1965: AND business_document_version = p_bus_doc_version
1966: AND recurring_del_parent_id = p_del_id

Line 2004: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;

2000:
2001: l_repeat_day_of_month number;
2002: l_repeat_day_of_week number;
2003:
2004: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
2005: l_has_instances_yn VARCHAR2(1);
2006:
2007: BEGIN
2008: -- initialize

Line 2598: UPDATE okc_deliverables

2594:
2595: IF deliverableIds.count > 0 THEN
2596: --- bulk update for deliverables actual due date
2597: FORALL i IN deliverableIds.FIRST..deliverableIds.LAST
2598: UPDATE okc_deliverables
2599: SET
2600: actual_due_date = deliverableDueDates(i),
2601: start_event_date = deliverableStartEventDates(i),
2602: end_event_date = deliverableEndEventDates(i),

Line 2723: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'

2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722:
2723: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'
2724: WHERE business_document_id = p_bus_doc_id
2725: AND business_document_type = p_bus_doc_type
2726: AND business_document_version = p_bus_doc_version;
2727:

Line 3112: UPDATE OKC_DELIVERABLES

3108:
3109: -- Initialize API return status to success
3110: x_return_status := FND_API.G_RET_STS_SUCCESS;
3111:
3112: UPDATE OKC_DELIVERABLES
3113: set internal_party_contact_id = p_new_buyer_id,
3114: last_updated_by= Fnd_Global.User_Id,
3115: last_update_date = sysdate,
3116: last_update_login=Fnd_Global.Login_Id

Line 3224: UPDATE OKC_DELIVERABLES

3220: END LOOP;
3221: END IF;
3222: --- bulk update for deliverables actual due date
3223: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3224: UPDATE OKC_DELIVERABLES
3225: set internal_party_contact_id = p_new_buyer_id,
3226: last_updated_by= Fnd_Global.User_Id,
3227: last_update_date = sysdate,
3228: last_update_login=Fnd_Global.Login_Id

Line 3433: UPDATE OKC_DELIVERABLES

3429: -- Initialize API return status to success
3430: x_return_status := FND_API.G_RET_STS_SUCCESS;
3431:
3432: --bug#4154567 update -99 version aswell
3433: UPDATE OKC_DELIVERABLES
3434: set internal_party_contact_id = p_new_internal_contact_id,
3435: last_updated_by= Fnd_Global.User_Id,
3436: last_update_date = sysdate,
3437: last_update_login=Fnd_Global.Login_Id

Line 3547: UPDATE OKC_DELIVERABLES

3543: END IF;
3544: --- bulk update for deliverables actual due date
3545: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3546: --bug#4154567 update -99 version aswell
3547: UPDATE OKC_DELIVERABLES
3548: set internal_party_contact_id = p_new_internal_contact_id,
3549: last_updated_by= Fnd_Global.User_Id,
3550: last_update_date = sysdate,
3551: last_update_login=Fnd_Global.Login_Id

Line 3643: UPDATE OKC_DELIVERABLES

3639:
3640: -- Initialize API return status to success
3641: x_return_status := FND_API.G_RET_STS_SUCCESS;
3642:
3643: UPDATE OKC_DELIVERABLES
3644: SET external_party_id = p_external_party_id,
3645: external_party_site_id = p_external_party_site_id,
3646: last_updated_by= Fnd_Global.User_Id,
3647: last_update_date = sysdate,

Line 3721: FROM okc_deliverables

3717: l_api_version CONSTANT VARCHAR2(30) := 1;
3718:
3719: CURSOR del_cur IS
3720: SELECT deliverable_id,external_party_site_id
3721: FROM okc_deliverables
3722: where external_party_id = p_from_external_party_id
3723: and business_document_type IN (select document_type
3724: from okc_bus_doc_types_b
3725: where document_type_class = p_document_class);

Line 3784: UPDATE okc_deliverables

3780:
3781: IF delIdTab.COUNT <> 0 THEN
3782: -- bulk update deliverables external party
3783: FORALL i IN delIdTab.FIRST..delIdTab.LAST
3784: UPDATE okc_deliverables
3785: SET external_party_id = p_to_external_party_id,
3786: external_party_site_id = delExtSiteIdTab(i),
3787: last_updated_by= Fnd_Global.User_Id,
3788: last_update_date = sysdate,

Line 3878: from okc_deliverables deliverable

3874: deliverable.deliverable_status,
3875: deliverable.status_change_notes,
3876: deliverable.deliverable_id,
3877: deliverable.notify_completed_yn
3878: from okc_deliverables deliverable
3879: where
3880: deliverable.deliverable_status <> 'INACTIVE' and
3881: business_document_id = p_bus_doc_id and
3882: business_document_type = p_bus_doc_type and

Line 3905: okc_deliverables deliverable,

3901: deliverable.status_change_notes,
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

Line 3988: WF_EVENT.raise2(p_event_name => 'oracle.apps.okc.deliverables.sendNotification',

3984: end if;
3985:
3986: begin
3987: --raise bus event to send notification
3988: WF_EVENT.raise2(p_event_name => 'oracle.apps.okc.deliverables.sendNotification',
3989: p_event_key => to_char(l_key),
3990: p_parameter_name1 => 'DELIVERABLE_ID',
3991: p_parameter_value1 => del_rec.deliverable_id,
3992: p_parameter_name2 => 'MSG_CODE',

Line 4094: FROM okc_deliverables

4090: IS
4091: --bug#4170483 removed check for responsible party. and added -99 version check
4092: CURSOR del_cur IS
4093: SELECT 'X'
4094: FROM okc_deliverables
4095: WHERE business_document_type = p_busdoc_type
4096: AND business_document_id = p_busdoc_id
4097: AND business_document_version =-99
4098: AND UPPER(external_party_role) = UPPER(p_external_party_role)

Line 4178: FROM okc_deliverables

4174: RETURN VARCHAR2
4175: IS
4176: CURSOR del_cur IS
4177: SELECT 'X'
4178: FROM okc_deliverables
4179: WHERE business_document_type = p_busdoc_type
4180: AND business_document_id = p_busdoc_id
4181: AND business_document_version = p_busdoc_version
4182: AND manage_yn = 'Y';

Line 4262: FROM okc_deliverables

4258: l_api_version CONSTANT VARCHAR2(30) := 1;
4259:
4260: CURSOR del_cur IS
4261: SELECT deliverable_id,external_party_site_id
4262: FROM okc_deliverables
4263: where external_party_id = NVL(p_from_external_party_id,external_party_id)
4264: and external_party_role <> 'SUPPLIER_ORG'
4265: and business_document_type IN (select document_type
4266: from okc_bus_doc_types_b

Line 4313: UPDATE okc_deliverables

4309:
4310: IF delIdTab.COUNT <> 0 THEN
4311: -- bulk update deliverables external party
4312: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4313: UPDATE okc_deliverables
4314: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4315: external_party_site_id = p_to_external_party_site_id,
4316: last_updated_by= Fnd_Global.User_Id,
4317: last_update_date = sysdate,

Line 4564: FROM okc_deliverables

4560: PAY_HOLD_PRIOR_DUE_DATE_VALUE,
4561: PAY_HOLD_PRIOR_DUE_DATE_UOM,
4562: PAY_HOLD_OVERDUE_YN,
4563: ACTUAL_DUE_DATE
4564: FROM okc_deliverables
4565: WHERE business_document_id = p_bus_doc_id
4566: AND business_document_version = p_bus_doc_version
4567: AND business_document_type = 'PO_STANDARD'
4568: AND deliverable_type = 'CONTRACTUAL'

Line 4663: FROM okc_deliverables

4659: PAY_HOLD_PRIOR_DUE_DATE_VALUE,
4660: PAY_HOLD_PRIOR_DUE_DATE_UOM,
4661: PAY_HOLD_OVERDUE_YN,
4662: ACTUAL_DUE_DATE
4663: FROM okc_deliverables
4664: WHERE deliverable_id = p_deliverable_id
4665: AND business_document_type = 'PO_STANDARD'
4666: AND deliverable_type = 'CONTRACTUAL'
4667: AND responsible_party = 'SUPPLIER_ORG'