APPS.AP_TERMS_CAL_EXISTS_PKG dependencies on AP_TERMS

Line 1: PACKAGE BODY AP_TERMS_CAL_EXISTS_PKG AS

1: PACKAGE BODY AP_TERMS_CAL_EXISTS_PKG AS
2: /*$Header: aptmcalb.pls 120.4 2005/05/12 11:21:25 sguddeti noship $*/
3:
4: PROCEDURE Check_For_Calendar
5: (p_terms_name IN varchar2,

Line 11: FROM ap_terms,

7: p_no_cal IN OUT NOCOPY varchar2,
8: p_calling_sequence IN varchar2) IS
9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;

Line 12: ap_terms_lines

8: p_calling_sequence IN varchar2) IS
9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:

Line 13: WHERE ap_terms.term_id = ap_terms_lines.term_id

9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);

Line 14: AND ap_terms.name = p_terms_name

10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);
18: l_cal_exists VARCHAR2(1);

Line 15: AND ap_terms_lines.calendar is not null;

11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);
18: l_cal_exists VARCHAR2(1);
19: l_debug_info VARCHAR2(100);

Line 26: 'AP_TERMS_CAL_EXISTS_PKG.Check_For_Calendar<-'||p_calling_sequence;

22: BEGIN
23: -- Update the calling sequence
24: --
25: l_curr_calling_sequence :=
26: 'AP_TERMS_CAL_EXISTS_PKG.Check_For_Calendar<-'||p_calling_sequence;
27:
28: --------------------------------------------------------
29: l_debug_info := 'OPEN cursor c';
30: --------------------------------------------------------

Line 89: END Ap_Terms_Cal_Exists_Pkg;

85: END IF;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: End Check_For_Calendar;
88:
89: END Ap_Terms_Cal_Exists_Pkg;