APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_BUS_DOC_EVENTS_B

Line 717: FROM OKC_BUS_DOC_EVENTS_B

713: BEGIN
714: -- IF p_end_event_yn = 'Y' THEN
715:
716: SELECT business_event_code, before_after into x_event_name, x_before_after
717: FROM OKC_BUS_DOC_EVENTS_B
718: WHERE bus_doc_event_id = p_event_id;
719:
720: /* AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'END');
721: ELSE

Line 723: FROM OKC_BUS_DOC_EVENTS_B

719:
720: /* AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'END');
721: ELSE
722: SELECT business_event_code, before_after into x_event_name, x_before_after
723: FROM OKC_BUS_DOC_EVENTS_B
724: WHERE bus_doc_event_id = p_event_id
725: AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'START');
726: END IF; */
727:

Line 965: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

961: p_end_event_yn IN VARCHAR2)
962: return DATE
963: IS
964: l_api_name CONSTANT VARCHAR2(30) := 'resolveRelativeDueEvents';
965: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
966: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
967: l_actual_date DATE;
968:
969: BEGIN

Line 966: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;

962: return DATE
963: IS
964: l_api_name CONSTANT VARCHAR2(30) := 'resolveRelativeDueEvents';
965: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
966: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
967: l_actual_date DATE;
968:
969: BEGIN
970:

Line 1096: from okc_bus_doc_events_b docEvents

1092: AND delTypes.document_type_class = busDocTypes.document_type_class
1093: AND del.deliverable_type = delTypes.deliverable_type_code)
1094: AND (G_FALSE = p_cancel_flag OR ( del.RELATIVE_ST_DATE_EVENT_ID in
1095: (select docEvents.BUS_DOC_EVENT_ID
1096: from okc_bus_doc_events_b docEvents
1097: where docEvents.BUSINESS_EVENT_CODE = p_event_code
1098: ))
1099: );
1100: del_rec del_cur%ROWTYPE;

Line 1996: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

1992:
1993: -- for storage recurrign instances
1994: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1995:
1996: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
1997: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
1998: l_actual_date DATE;
1999: l_recurr_end_date DATE;
2000:

Line 1997: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;

1993: -- for storage recurrign instances
1994: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1995:
1996: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
1997: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
1998: l_actual_date DATE;
1999: l_recurr_end_date DATE;
2000:
2001: l_repeat_day_of_month number;