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 260: SELECT deliverable_id,ACTUAL_DUE_DATE,RECURRING_DEL_PARENT_ID FROM OKC_DELIVERABLES DEL

256: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
257: delStsTab1 OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
258: /* Bug 10048345 */
259: CURSOR find_if_deliverable_exists(ACTUAL_DUE_DATE_passed IN DATE , RECURRING_DEL_PARENT_ID_passed IN NUMBER) IS
260: SELECT deliverable_id,ACTUAL_DUE_DATE,RECURRING_DEL_PARENT_ID FROM OKC_DELIVERABLES DEL
261: WHERE DEL.RECURRING_DEL_PARENT_ID= RECURRING_DEL_PARENT_ID_passed
262: AND DEL.ACTUAL_DUE_DATE = ACTUAL_DUE_DATE_passed ;
263: del_find_rec find_if_deliverable_exists%ROWTYPE;
264: /* Bug 10048345 */

Line 473: INSERT INTO okc_deliverables

469:
470: IF delInstanceRecTab.count > 0 THEN
471:
472: FOR i IN delInstanceRecTab.FIRST..delInstanceRecTab.LAST LOOP
473: INSERT INTO okc_deliverables
474: (DELIVERABLE_ID,
475: BUSINESS_DOCUMENT_TYPE ,
476: BUSINESS_DOCUMENT_ID ,
477: BUSINESS_DOCUMENT_NUMBER ,

Line 777: * event id, stored in OKC_DELIVERABLES

773: END;
774:
775: /**
776: * Helper method to return Event Code and Before After value for given
777: * event id, stored in OKC_DELIVERABLES
778: */
779: PROCEDURE getDelEventDetails(
780: p_event_id IN NUMBER,
781: p_end_event_yn IN varchar2,

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

1125: return l_actual_date;
1126: END;
1127:
1128: /**
1129: * Resolve deliverable due date, recurring instances to OKC_DELIVERABLES
1130: */
1131: PROCEDURE resolveDeliverables (
1132: p_api_version IN NUMBER,
1133: p_init_msg_list IN VARCHAR2,

Line 1154: FROM okc_deliverables del

1150: start_date_for_del date;
1151: -- update cursor for bug#4069955
1152: CURSOR del_cur IS
1153: SELECT *
1154: FROM okc_deliverables del
1155: WHERE del.business_document_id = p_bus_doc_id
1156: AND del.business_document_version = p_bus_doc_version
1157: AND del.business_document_type = p_bus_doc_type
1158: AND del.deliverable_status = 'INACTIVE'

Line 1179: SELECT deliverable_id FROM OKC_DELIVERABLES

1175: );
1176: del_rec del_cur%ROWTYPE;
1177:
1178: CURSOR get_del_ids_cur (p_del_id IN NUMBER, p_actual_date IN DATE) IS
1179: SELECT deliverable_id FROM OKC_DELIVERABLES
1180: WHERE business_document_id = p_bus_doc_id
1181: AND business_document_type = p_bus_doc_type
1182: AND business_document_version = p_bus_doc_version
1183: AND recurring_del_parent_id = p_del_id

Line 1190: SELECT deliverable_id FROM OKC_DELIVERABLES

1186: -- this cursor has been introduced to fix bug 3574466. The cursor
1187: -- collectes deliverable_id's of all the instances for given recurring
1188: -- deliverable
1189: CURSOR get_del_ids_cur2 (p_del_id IN NUMBER) IS
1190: SELECT deliverable_id FROM OKC_DELIVERABLES
1191: WHERE business_document_id = p_bus_doc_id
1192: AND business_document_type = p_bus_doc_type
1193: AND business_document_version = p_bus_doc_version
1194: AND recurring_del_parent_id = p_del_id;

Line 1227: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;

1223: l_repeat_day_of_week number;
1224:
1225: l_has_instances_yn VARCHAR2(1);
1226:
1227: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
1228:
1229: --- for deliverable ids
1230: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
1231:

Line 1938: UPDATE okc_deliverables

1934:
1935: --- bulk update for deliverables actual due date
1936: IF deliverableIds.count > 0 THEN
1937: FORALL i IN deliverableIds.FIRST..deliverableIds.LAST
1938: UPDATE okc_deliverables
1939: SET
1940: actual_due_date = deliverableDueDates(i),
1941: start_event_date = deliverableStartEventDates(i),
1942: end_event_date = deliverableEndEventDates(i),

Line 2034: FROM okc_deliverables del

2030: -- update cursor for bug#4069955
2031: -- Updated the cusror bug 5018624
2032: CURSOR del_cur IS
2033: SELECT *
2034: FROM okc_deliverables del
2035: WHERE business_document_id = p_bus_doc_id
2036: AND business_document_type = p_bus_doc_type
2037: AND business_document_version = p_bus_doc_version
2038: AND (

Line 2058: SELECT deliverable_id FROM OKC_DELIVERABLES

2054: );
2055: del_rec del_cur%ROWTYPE;
2056: k PLS_INTEGER;
2057: CURSOR get_del_ids_cur1 (p_del_id IN NUMBER) IS
2058: SELECT deliverable_id FROM OKC_DELIVERABLES
2059: WHERE business_document_id = p_bus_doc_id
2060: AND business_document_type = p_bus_doc_type
2061: AND business_document_version = p_bus_doc_version
2062: AND recurring_del_parent_id = p_del_id;

Line 2065: SELECT deliverable_id FROM OKC_DELIVERABLES

2061: AND business_document_version = p_bus_doc_version
2062: AND recurring_del_parent_id = p_del_id;
2063:
2064: CURSOR get_del_ids_cur2 (p_del_id IN NUMBER, p_actual_date IN DATE) IS
2065: SELECT deliverable_id FROM OKC_DELIVERABLES
2066: WHERE business_document_id = p_bus_doc_id
2067: AND business_document_type = p_bus_doc_type
2068: AND business_document_version = p_bus_doc_version
2069: AND recurring_del_parent_id = p_del_id

Line 2107: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;

2103:
2104: l_repeat_day_of_month number;
2105: l_repeat_day_of_week number;
2106:
2107: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
2108: l_has_instances_yn VARCHAR2(1);
2109:
2110: BEGIN
2111: -- initialize

Line 2718: UPDATE okc_deliverables

2714:
2715: IF deliverableIds.count > 0 THEN
2716: --- bulk update for deliverables actual due date
2717: FORALL i IN deliverableIds.FIRST..deliverableIds.LAST
2718: UPDATE okc_deliverables
2719: SET
2720: actual_due_date = deliverableDueDates(i),
2721: start_event_date = deliverableStartEventDates(i),
2722: end_event_date = deliverableEndEventDates(i),

Line 2843: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'

2839:
2840: -- Initialize API return status to success
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'
2844: WHERE business_document_id = p_bus_doc_id
2845: AND business_document_type = p_bus_doc_type
2846: AND business_document_version = p_bus_doc_version;
2847:

Line 3232: UPDATE OKC_DELIVERABLES

3228:
3229: -- Initialize API return status to success
3230: x_return_status := FND_API.G_RET_STS_SUCCESS;
3231:
3232: UPDATE OKC_DELIVERABLES
3233: set internal_party_contact_id = p_new_buyer_id,
3234: last_updated_by= Fnd_Global.User_Id,
3235: last_update_date = sysdate,
3236: last_update_login=Fnd_Global.Login_Id

Line 3344: UPDATE OKC_DELIVERABLES

3340: END LOOP;
3341: END IF;
3342: --- bulk update for deliverables actual due date
3343: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3344: UPDATE OKC_DELIVERABLES
3345: set internal_party_contact_id = p_new_buyer_id,
3346: last_updated_by= Fnd_Global.User_Id,
3347: last_update_date = sysdate,
3348: last_update_login=Fnd_Global.Login_Id

Line 3553: UPDATE OKC_DELIVERABLES

3549: -- Initialize API return status to success
3550: x_return_status := FND_API.G_RET_STS_SUCCESS;
3551:
3552: --bug#4154567 update -99 version aswell
3553: UPDATE OKC_DELIVERABLES
3554: set internal_party_contact_id = p_new_internal_contact_id,
3555: last_updated_by= Fnd_Global.User_Id,
3556: last_update_date = sysdate,
3557: last_update_login=Fnd_Global.Login_Id

Line 3667: UPDATE OKC_DELIVERABLES

3663: END IF;
3664: --- bulk update for deliverables actual due date
3665: FORALL j IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST
3666: --bug#4154567 update -99 version aswell
3667: UPDATE OKC_DELIVERABLES
3668: set internal_party_contact_id = p_new_internal_contact_id,
3669: last_updated_by= Fnd_Global.User_Id,
3670: last_update_date = sysdate,
3671: last_update_login=Fnd_Global.Login_Id

Line 3763: UPDATE OKC_DELIVERABLES

3759:
3760: -- Initialize API return status to success
3761: x_return_status := FND_API.G_RET_STS_SUCCESS;
3762:
3763: UPDATE OKC_DELIVERABLES
3764: SET external_party_id = p_external_party_id,
3765: external_party_site_id = p_external_party_site_id,
3766: last_updated_by= Fnd_Global.User_Id,
3767: last_update_date = sysdate,

Line 3841: FROM okc_deliverables

3837: l_api_version CONSTANT VARCHAR2(30) := 1;
3838:
3839: CURSOR del_cur IS
3840: SELECT deliverable_id,external_party_site_id
3841: FROM okc_deliverables
3842: where external_party_id = p_from_external_party_id
3843: and business_document_type IN (select document_type
3844: from okc_bus_doc_types_b
3845: where document_type_class = p_document_class);

Line 3904: UPDATE okc_deliverables

3900:
3901: IF delIdTab.COUNT <> 0 THEN
3902: -- bulk update deliverables external party
3903: FORALL i IN delIdTab.FIRST..delIdTab.LAST
3904: UPDATE okc_deliverables
3905: SET external_party_id = p_to_external_party_id,
3906: external_party_site_id = delExtSiteIdTab(i),
3907: last_updated_by= Fnd_Global.User_Id,
3908: last_update_date = sysdate,

Line 3998: from okc_deliverables deliverable

3994: deliverable.deliverable_status,
3995: deliverable.status_change_notes,
3996: deliverable.deliverable_id,
3997: deliverable.notify_completed_yn
3998: from okc_deliverables deliverable
3999: where
4000: deliverable.deliverable_status <> 'INACTIVE' and
4001: business_document_id = p_bus_doc_id and
4002: business_document_type = p_bus_doc_type and

Line 4025: okc_deliverables deliverable,

4021: deliverable.status_change_notes,
4022: deliverable.deliverable_id,
4023: status_history.status_change_date
4024: from
4025: okc_deliverables deliverable,
4026: okc_del_status_history status_history
4027: where
4028: deliverable.deliverable_status <> 'INACTIVE' and
4029: business_document_id = p_bus_doc_id and

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

4129: l_msg_code := l_resolved_msg_name;
4130:
4131: begin
4132: --raise bus event to send notification
4133: WF_EVENT.raise2(p_event_name => 'oracle.apps.okc.deliverables.sendNotification',
4134: p_event_key => to_char(l_key),
4135: p_parameter_name1 => 'DELIVERABLE_ID',
4136: p_parameter_value1 => del_rec.deliverable_id,
4137: p_parameter_name2 => 'MSG_CODE',

Line 4239: FROM okc_deliverables

4235: IS
4236: --bug#4170483 removed check for responsible party. and added -99 version check
4237: CURSOR del_cur IS
4238: SELECT 'X'
4239: FROM okc_deliverables
4240: WHERE business_document_type = p_busdoc_type
4241: AND business_document_id = p_busdoc_id
4242: AND business_document_version =-99
4243: AND UPPER(external_party_role) = UPPER(p_external_party_role)

Line 4323: FROM okc_deliverables

4319: RETURN VARCHAR2
4320: IS
4321: CURSOR del_cur IS
4322: SELECT 'X'
4323: FROM okc_deliverables
4324: WHERE business_document_type = p_busdoc_type
4325: AND business_document_id = p_busdoc_id
4326: AND business_document_version = p_busdoc_version
4327: AND manage_yn = 'Y';

Line 4407: FROM okc_deliverables

4403: l_api_version CONSTANT VARCHAR2(30) := 1;
4404:
4405: CURSOR del_cur IS
4406: SELECT deliverable_id,external_party_site_id
4407: FROM okc_deliverables
4408: where external_party_id = NVL(p_from_external_party_id,external_party_id)
4409: and external_party_role <> 'SUPPLIER_ORG'
4410: and business_document_type IN (select document_type
4411: from okc_bus_doc_types_b

Line 4458: UPDATE okc_deliverables

4454:
4455: IF delIdTab.COUNT <> 0 THEN
4456: -- bulk update deliverables external party
4457: FORALL i IN delIdTab.FIRST..delIdTab.LAST
4458: UPDATE okc_deliverables
4459: SET external_party_id = NVL(p_to_external_party_id,external_party_id),
4460: external_party_site_id = p_to_external_party_site_id,
4461: last_updated_by= Fnd_Global.User_Id,
4462: last_update_date = sysdate,

Line 4709: FROM okc_deliverables

4705: PAY_HOLD_PRIOR_DUE_DATE_VALUE,
4706: PAY_HOLD_PRIOR_DUE_DATE_UOM,
4707: PAY_HOLD_OVERDUE_YN,
4708: ACTUAL_DUE_DATE
4709: FROM okc_deliverables
4710: WHERE business_document_id = p_bus_doc_id
4711: AND business_document_version = p_bus_doc_version
4712: AND business_document_type = 'PO_STANDARD'
4713: AND deliverable_type = 'CONTRACTUAL'

Line 4808: FROM okc_deliverables

4804: PAY_HOLD_PRIOR_DUE_DATE_VALUE,
4805: PAY_HOLD_PRIOR_DUE_DATE_UOM,
4806: PAY_HOLD_OVERDUE_YN,
4807: ACTUAL_DUE_DATE
4808: FROM okc_deliverables
4809: WHERE deliverable_id = p_deliverable_id
4810: AND business_document_type = 'PO_STANDARD'
4811: AND deliverable_type = 'CONTRACTUAL'
4812: AND responsible_party = 'SUPPLIER_ORG'