APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_BUS_DOC_EVENTS_B

Line 791: FROM OKC_BUS_DOC_EVENTS_B

787: BEGIN
788: -- IF p_end_event_yn = 'Y' THEN
789:
790: SELECT business_event_code, before_after into x_event_name, x_before_after
791: FROM OKC_BUS_DOC_EVENTS_B
792: WHERE bus_doc_event_id = p_event_id;
793:
794: /* AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'END');
795: ELSE

Line 797: FROM OKC_BUS_DOC_EVENTS_B

793:
794: /* AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'END');
795: ELSE
796: SELECT business_event_code, before_after into x_event_name, x_before_after
797: FROM OKC_BUS_DOC_EVENTS_B
798: WHERE bus_doc_event_id = p_event_id
799: AND (start_end_qualifier = 'BOTH' or start_end_qualifier = 'START');
800: END IF; */
801:

Line 1039: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

1035: p_end_event_yn IN VARCHAR2)
1036: return DATE
1037: IS
1038: l_api_name CONSTANT VARCHAR2(30) := 'resolveRelativeDueEvents';
1039: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
1040: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
1041: l_actual_date DATE;
1042:
1043: BEGIN

Line 1040: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;

1036: return DATE
1037: IS
1038: l_api_name CONSTANT VARCHAR2(30) := 'resolveRelativeDueEvents';
1039: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
1040: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
1041: l_actual_date DATE;
1042:
1043: BEGIN
1044:

Line 1172: from okc_bus_doc_events_b docEvents

1168: AND delTypes.document_type_class = busDocTypes.document_type_class
1169: AND del.deliverable_type = delTypes.deliverable_type_code)
1170: AND (G_FALSE = p_cancel_flag OR ( del.RELATIVE_ST_DATE_EVENT_ID in
1171: (select docEvents.BUS_DOC_EVENT_ID
1172: from okc_bus_doc_events_b docEvents
1173: where docEvents.BUSINESS_EVENT_CODE = p_event_code
1174: ))
1175: );
1176: del_rec del_cur%ROWTYPE;

Line 2099: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;

2095:
2096: -- for storage recurrign instances
2097: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2098:
2099: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
2100: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
2101: l_actual_date DATE;
2102: l_recurr_end_date DATE;
2103:

Line 2100: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;

2096: -- for storage recurrign instances
2097: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2098:
2099: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
2100: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
2101: l_actual_date DATE;
2102: l_recurr_end_date DATE;
2103:
2104: l_repeat_day_of_month number;