APPS.PO_DATES_S dependencies on PO_DATES_S

Line 1: PACKAGE BODY PO_DATES_S AS

1: PACKAGE BODY PO_DATES_S AS
2: /* $Header: POXCODAB.pls 115.9 2004/05/26 00:34:59 spangulu ship $*/
3: /*===========================================================================
4:
5: FUNCTION NAME: val_open_period()

Line 36: IF (PO_DATES_S.x_po_install_status is NULL) THEN

32: */
33:
34: IF (x_app_name = 'PO') THEN
35:
36: IF (PO_DATES_S.x_po_install_status is NULL) THEN
37: /* derive and cache po_install_status */
38: PO_DATES_S.x_po_install_status := PO_CORE_S.get_product_install_status(x_app_name);
39: END IF;
40:

Line 38: PO_DATES_S.x_po_install_status := PO_CORE_S.get_product_install_status(x_app_name);

34: IF (x_app_name = 'PO') THEN
35:
36: IF (PO_DATES_S.x_po_install_status is NULL) THEN
37: /* derive and cache po_install_status */
38: PO_DATES_S.x_po_install_status := PO_CORE_S.get_product_install_status(x_app_name);
39: END IF;
40:
41: IF (PO_DATES_S.x_po_install_status = 'I') THEN
42:

Line 41: IF (PO_DATES_S.x_po_install_status = 'I') THEN

37: /* derive and cache po_install_status */
38: PO_DATES_S.x_po_install_status := PO_CORE_S.get_product_install_status(x_app_name);
39: END IF;
40:
41: IF (PO_DATES_S.x_po_install_status = 'I') THEN
42:
43: IF (PO_DATES_S.x_po_app_id IS NULL) THEN
44: /* derive and cache app_id */
45: PO_DATES_S.x_po_app_id := get_app_id(x_app_name);

Line 43: IF (PO_DATES_S.x_po_app_id IS NULL) THEN

39: END IF;
40:
41: IF (PO_DATES_S.x_po_install_status = 'I') THEN
42:
43: IF (PO_DATES_S.x_po_app_id IS NULL) THEN
44: /* derive and cache app_id */
45: PO_DATES_S.x_po_app_id := get_app_id(x_app_name);
46: END IF;
47:

Line 45: PO_DATES_S.x_po_app_id := get_app_id(x_app_name);

41: IF (PO_DATES_S.x_po_install_status = 'I') THEN
42:
43: IF (PO_DATES_S.x_po_app_id IS NULL) THEN
44: /* derive and cache app_id */
45: PO_DATES_S.x_po_app_id := get_app_id(x_app_name);
46: END IF;
47:
48: -- Bug 3647806: Remove caching of po_closed_status
49: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date

Line 49: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date

45: PO_DATES_S.x_po_app_id := get_app_id(x_app_name);
46: END IF;
47:
48: -- Bug 3647806: Remove caching of po_closed_status
49: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date
50: , x_sob_id => x_sob_id
51: , x_app_id => PO_DATES_S.x_po_app_id
52: )
53: NOT IN ('O', 'F'))

Line 51: , x_app_id => PO_DATES_S.x_po_app_id

47:
48: -- Bug 3647806: Remove caching of po_closed_status
49: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date
50: , x_sob_id => x_sob_id
51: , x_app_id => PO_DATES_S.x_po_app_id
52: )
53: NOT IN ('O', 'F'))
54: THEN
55: RETURN(FALSE);

Line 62: IF (PO_DATES_S.x_inv_install_status is NULL) THEN

58: END IF; /* x_po_install_status = 'I' */
59:
60: ELSIF (x_app_name = 'INV') THEN
61:
62: IF (PO_DATES_S.x_inv_install_status is NULL) THEN
63: /* derive and cache inv_install_status */
64: PO_DATES_S.x_inv_install_status := PO_CORE_S.get_product_install_status(x_app_name);
65: END IF;
66:

Line 64: PO_DATES_S.x_inv_install_status := PO_CORE_S.get_product_install_status(x_app_name);

60: ELSIF (x_app_name = 'INV') THEN
61:
62: IF (PO_DATES_S.x_inv_install_status is NULL) THEN
63: /* derive and cache inv_install_status */
64: PO_DATES_S.x_inv_install_status := PO_CORE_S.get_product_install_status(x_app_name);
65: END IF;
66:
67: IF (PO_DATES_S.x_inv_install_status = 'I') THEN
68:

Line 67: IF (PO_DATES_S.x_inv_install_status = 'I') THEN

63: /* derive and cache inv_install_status */
64: PO_DATES_S.x_inv_install_status := PO_CORE_S.get_product_install_status(x_app_name);
65: END IF;
66:
67: IF (PO_DATES_S.x_inv_install_status = 'I') THEN
68:
69: -- Bug 3647806: Store inv_app_id in x_inv_app_id
70: -- Also, changed get_app_id('SQLGL') to get_app_id('INV'), which is correct for inv
71: IF (PO_DATES_S.x_inv_app_id is NULL) THEN

Line 71: IF (PO_DATES_S.x_inv_app_id is NULL) THEN

67: IF (PO_DATES_S.x_inv_install_status = 'I') THEN
68:
69: -- Bug 3647806: Store inv_app_id in x_inv_app_id
70: -- Also, changed get_app_id('SQLGL') to get_app_id('INV'), which is correct for inv
71: IF (PO_DATES_S.x_inv_app_id is NULL) THEN
72: PO_DATES_S.x_inv_app_id := get_app_id('INV');
73: END IF;
74:
75: -- Bug 3647806: Remove caching of inv_closed_status

Line 72: PO_DATES_S.x_inv_app_id := get_app_id('INV');

68:
69: -- Bug 3647806: Store inv_app_id in x_inv_app_id
70: -- Also, changed get_app_id('SQLGL') to get_app_id('INV'), which is correct for inv
71: IF (PO_DATES_S.x_inv_app_id is NULL) THEN
72: PO_DATES_S.x_inv_app_id := get_app_id('INV');
73: END IF;
74:
75: -- Bug 3647806: Remove caching of inv_closed_status
76: IF (PO_DATES_S.get_acct_period_status( x_trx_date => x_trx_date

Line 76: IF (PO_DATES_S.get_acct_period_status( x_trx_date => x_trx_date

72: PO_DATES_S.x_inv_app_id := get_app_id('INV');
73: END IF;
74:
75: -- Bug 3647806: Remove caching of inv_closed_status
76: IF (PO_DATES_S.get_acct_period_status( x_trx_date => x_trx_date
77: , x_sob_id => x_sob_id
78: , x_app_id => PO_DATES_S.x_inv_app_id
79: , x_org_id => x_org_id
80: )

Line 78: , x_app_id => PO_DATES_S.x_inv_app_id

74:
75: -- Bug 3647806: Remove caching of inv_closed_status
76: IF (PO_DATES_S.get_acct_period_status( x_trx_date => x_trx_date
77: , x_sob_id => x_sob_id
78: , x_app_id => PO_DATES_S.x_inv_app_id
79: , x_org_id => x_org_id
80: )
81: NOT IN ('O', 'F'))
82: THEN

Line 94: IF (PO_DATES_S.x_sqlgl_install_status is NULL) THEN

90:
91: /* Bug 3647806: Also cached gl install status. */
92: IF (x_app_name = 'SQLGL') THEN
93:
94: IF (PO_DATES_S.x_sqlgl_install_status is NULL) THEN
95: /* derive and cache gl_install_status */
96: PO_DATES_S.x_sqlgl_install_status := PO_CORE_S.get_product_install_status(x_app_name);
97: END IF;
98:

Line 96: PO_DATES_S.x_sqlgl_install_status := PO_CORE_S.get_product_install_status(x_app_name);

92: IF (x_app_name = 'SQLGL') THEN
93:
94: IF (PO_DATES_S.x_sqlgl_install_status is NULL) THEN
95: /* derive and cache gl_install_status */
96: PO_DATES_S.x_sqlgl_install_status := PO_CORE_S.get_product_install_status(x_app_name);
97: END IF;
98:
99: END IF;
100:

Line 101: IF ((PO_DATES_S.x_sqlgl_install_status = 'I') OR

97: END IF;
98:
99: END IF;
100:
101: IF ((PO_DATES_S.x_sqlgl_install_status = 'I') OR
102: (PO_CORE_S.get_product_install_status(x_app_name) = 'I')) THEN
103:
104: IF (PO_DATES_S.x_sqlgl_app_id is NULL) THEN
105: /* derive and cache gl_app_id in x_sqlgl_app_id */

Line 104: IF (PO_DATES_S.x_sqlgl_app_id is NULL) THEN

100:
101: IF ((PO_DATES_S.x_sqlgl_install_status = 'I') OR
102: (PO_CORE_S.get_product_install_status(x_app_name) = 'I')) THEN
103:
104: IF (PO_DATES_S.x_sqlgl_app_id is NULL) THEN
105: /* derive and cache gl_app_id in x_sqlgl_app_id */
106: PO_DATES_S.x_sqlgl_app_id := get_app_id('SQLGL');
107: END IF;
108:

Line 106: PO_DATES_S.x_sqlgl_app_id := get_app_id('SQLGL');

102: (PO_CORE_S.get_product_install_status(x_app_name) = 'I')) THEN
103:
104: IF (PO_DATES_S.x_sqlgl_app_id is NULL) THEN
105: /* derive and cache gl_app_id in x_sqlgl_app_id */
106: PO_DATES_S.x_sqlgl_app_id := get_app_id('SQLGL');
107: END IF;
108:
109: -- Bug 3647806: Remove caching of gl_closed_status
110: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date

Line 110: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date

106: PO_DATES_S.x_sqlgl_app_id := get_app_id('SQLGL');
107: END IF;
108:
109: -- Bug 3647806: Remove caching of gl_closed_status
110: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date
111: , x_sob_id => x_sob_id
112: , x_app_id => PO_DATES_S.x_sqlgl_app_id
113: )
114: NOT IN ('O', 'F'))

Line 112: , x_app_id => PO_DATES_S.x_sqlgl_app_id

108:
109: -- Bug 3647806: Remove caching of gl_closed_status
110: IF (PO_DATES_S.get_closing_status( x_trx_date => x_trx_date
111: , x_sob_id => x_sob_id
112: , x_app_id => PO_DATES_S.x_sqlgl_app_id
113: )
114: NOT IN ('O', 'F'))
115: THEN
116: RETURN(FALSE);

Line 282: END PO_DATES_S;

278: RAISE;
279:
280: END get_acct_period_status;
281:
282: END PO_DATES_S;