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.JG_ZZ_SHARED_PKG dependencies on JG_ZZ_SHARED_PKG

Line 1: PACKAGE BODY JG_ZZ_SHARED_PKG AS

1: PACKAGE BODY JG_ZZ_SHARED_PKG AS
2: /* $Header: jgzzssab.pls 120.18 2008/01/23 07:18:55 gkumares ship $ */
3:
4: FUNCTION CHECK_CACHE(p_org_id IN NUMBER,
5: p_ledger_id IN NUMBER,

Line 13: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN

9: RETURN VARCHAR2 IS
10: BEGIN
11: IF p_org_id is NOT NULL THEN
12: IF p_type = 'COUNTRY' THEN
13: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
14: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
15: END IF;
16: ELSIF p_type = 'PRODUCT' THEN
17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN

Line 14: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));

10: BEGIN
11: IF p_org_id is NOT NULL THEN
12: IF p_type = 'COUNTRY' THEN
13: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
14: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
15: END IF;
16: ELSIF p_type = 'PRODUCT' THEN
17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));

Line 17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN

13: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
14: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
15: END IF;
16: ELSIF p_type = 'PRODUCT' THEN
17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
19: END IF;
20: ELSIF p_type = 'APPL' THEN
21: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN

Line 18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));

14: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
15: END IF;
16: ELSIF p_type = 'PRODUCT' THEN
17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
19: END IF;
20: ELSIF p_type = 'APPL' THEN
21: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
22: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));

Line 21: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN

17: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
19: END IF;
20: ELSIF p_type = 'APPL' THEN
21: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
22: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));
23: END IF;
24: END IF;
25:

Line 22: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));

18: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
19: END IF;
20: ELSIF p_type = 'APPL' THEN
21: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
22: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));
23: END IF;
24: END IF;
25:
26: ELSIF p_ledger_id is NOT NULL THEN

Line 28: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

24: END IF;
25:
26: ELSIF p_ledger_id is NOT NULL THEN
27: IF p_type = 'COUNTRY' THEN
28: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
29: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
30: END IF;
31: ELSIF p_type = 'PRODUCT' THEN
32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

Line 29: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));

25:
26: ELSIF p_ledger_id is NOT NULL THEN
27: IF p_type = 'COUNTRY' THEN
28: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
29: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
30: END IF;
31: ELSIF p_type = 'PRODUCT' THEN
32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));

Line 32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

28: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
29: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
30: END IF;
31: ELSIF p_type = 'PRODUCT' THEN
32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
34: END IF;
35: ELSIF p_type = 'APPL' THEN
36: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

Line 33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));

29: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
30: END IF;
31: ELSIF p_type = 'PRODUCT' THEN
32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
34: END IF;
35: ELSIF p_type = 'APPL' THEN
36: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
37: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));

Line 36: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

32: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
34: END IF;
35: ELSIF p_type = 'APPL' THEN
36: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
37: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));
38: END IF;
39: END IF;
40:

Line 37: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));

33: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
34: END IF;
35: ELSIF p_type = 'APPL' THEN
36: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
37: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));
38: END IF;
39: END IF;
40:
41: ELSIF p_inv_org_id is NOT NULL THEN

Line 43: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

39: END IF;
40:
41: ELSIF p_inv_org_id is NOT NULL THEN
42: IF p_type = 'COUNTRY' THEN
43: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
44: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
45: END IF;
46: ELSIF p_type = 'PRODUCT' THEN
47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

Line 44: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));

40:
41: ELSIF p_inv_org_id is NOT NULL THEN
42: IF p_type = 'COUNTRY' THEN
43: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
44: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
45: END IF;
46: ELSIF p_type = 'PRODUCT' THEN
47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));

Line 47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

43: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
44: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
45: END IF;
46: ELSIF p_type = 'PRODUCT' THEN
47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
49: END IF;
50: ELSIF p_type = 'APPL' THEN
51: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

Line 48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));

44: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
45: END IF;
46: ELSIF p_type = 'PRODUCT' THEN
47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
49: END IF;
50: ELSIF p_type = 'APPL' THEN
51: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
52: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));

Line 51: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

47: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
49: END IF;
50: ELSIF p_type = 'APPL' THEN
51: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
52: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));
53: END IF;
54: END IF;
55:

Line 52: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));

48: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
49: END IF;
50: ELSIF p_type = 'APPL' THEN
51: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
52: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));
53: END IF;
54: END IF;
55:
56: ELSIF p_resp_id is NOT NULL THEN

Line 58: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

54: END IF;
55:
56: ELSIF p_resp_id is NOT NULL THEN
57: IF p_type = 'COUNTRY' THEN
58: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
59: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
60: END IF;
61: ELSIF p_type = 'PRODUCT' THEN
62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

Line 59: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));

55:
56: ELSIF p_resp_id is NOT NULL THEN
57: IF p_type = 'COUNTRY' THEN
58: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
59: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
60: END IF;
61: ELSIF p_type = 'PRODUCT' THEN
62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));

Line 62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

58: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
59: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
60: END IF;
61: ELSIF p_type = 'PRODUCT' THEN
62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
64: END IF;
65: ELSIF p_type = 'APPL' THEN
66: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

Line 63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));

59: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
60: END IF;
61: ELSIF p_type = 'PRODUCT' THEN
62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
64: END IF;
65: ELSIF p_type = 'APPL' THEN
66: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
67: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));

Line 66: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

62: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
64: END IF;
65: ELSIF p_type = 'APPL' THEN
66: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
67: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));
68: END IF;
69: END IF;
70:

Line 67: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));

63: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
64: END IF;
65: ELSIF p_type = 'APPL' THEN
66: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
67: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));
68: END IF;
69: END IF;
70:
71: END IF;

Line 86: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;

82: IS
83: BEGIN
84: IF p_org_id is NOT NULL THEN
85: IF p_type = 'COUNTRY' THEN
86: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
87: ELSIF p_type = 'PRODUCT' THEN
88: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
89: ELSIF p_type = 'APPL' THEN
90: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;

Line 88: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;

84: IF p_org_id is NOT NULL THEN
85: IF p_type = 'COUNTRY' THEN
86: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
87: ELSIF p_type = 'PRODUCT' THEN
88: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
89: ELSIF p_type = 'APPL' THEN
90: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;
91: END IF;
92:

Line 90: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;

86: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
87: ELSIF p_type = 'PRODUCT' THEN
88: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
89: ELSIF p_type = 'APPL' THEN
90: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;
91: END IF;
92:
93: ELSIF p_ledger_id is NOT NULL THEN
94: IF p_type = 'COUNTRY' THEN

Line 95: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;

91: END IF;
92:
93: ELSIF p_ledger_id is NOT NULL THEN
94: IF p_type = 'COUNTRY' THEN
95: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
96: ELSIF p_type = 'PRODUCT' THEN
97: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
98: ELSIF p_type = 'APPL' THEN
99: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;

Line 97: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;

93: ELSIF p_ledger_id is NOT NULL THEN
94: IF p_type = 'COUNTRY' THEN
95: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
96: ELSIF p_type = 'PRODUCT' THEN
97: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
98: ELSIF p_type = 'APPL' THEN
99: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;
100: END IF;
101:

Line 99: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;

95: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
96: ELSIF p_type = 'PRODUCT' THEN
97: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
98: ELSIF p_type = 'APPL' THEN
99: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;
100: END IF;
101:
102: ELSIF p_inv_org_id is NOT NULL THEN
103: IF p_type = 'COUNTRY' THEN

Line 104: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;

100: END IF;
101:
102: ELSIF p_inv_org_id is NOT NULL THEN
103: IF p_type = 'COUNTRY' THEN
104: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
105: ELSIF p_type = 'PRODUCT' THEN
106: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
107: ELSIF p_type = 'APPL' THEN
108: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;

Line 106: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;

102: ELSIF p_inv_org_id is NOT NULL THEN
103: IF p_type = 'COUNTRY' THEN
104: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
105: ELSIF p_type = 'PRODUCT' THEN
106: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
107: ELSIF p_type = 'APPL' THEN
108: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
109: END IF;
110:

Line 108: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;

104: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
105: ELSIF p_type = 'PRODUCT' THEN
106: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
107: ELSIF p_type = 'APPL' THEN
108: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
109: END IF;
110:
111: ELSIF p_resp_id is NOT NULL THEN
112: IF p_type = 'COUNTRY' THEN

Line 113: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;

109: END IF;
110:
111: ELSIF p_resp_id is NOT NULL THEN
112: IF p_type = 'COUNTRY' THEN
113: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
114: ELSIF p_type = 'PRODUCT' THEN
115: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
116: ELSIF p_type = 'APPL' THEN
117: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;

Line 115: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;

111: ELSIF p_resp_id is NOT NULL THEN
112: IF p_type = 'COUNTRY' THEN
113: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
114: ELSIF p_type = 'PRODUCT' THEN
115: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
116: ELSIF p_type = 'APPL' THEN
117: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;
118: END IF;
119: END IF;

Line 117: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;

113: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
114: ELSIF p_type = 'PRODUCT' THEN
115: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
116: ELSIF p_type = 'APPL' THEN
117: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;
118: END IF;
119: END IF;
120:
121: END PUT_CACHE;

Line 136: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,

132: return l_result;
133: END IF;
134: l_country_code := fnd_profile.value('JGZZ_COUNTRY_CODE');
135:
136: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
137: p_ledger_id => NULL,
138: p_inv_org_id => NULL,
139: p_resp_id => FND_GLOBAL.RESP_ID,
140: p_type => 'COUNTRY',

Line 290: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,

286: l_country_code := l_Inv_Le_info_rec(l_Inv_Le_info_rec.FIRST).COUNTRY;
287: END IF;
288:
289: END IF;
290: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,
291: p_ledger_id => p_ledger_id,
292: p_inv_org_id => p_inv_org_id,
293: p_resp_id => NULL,
294: p_type => 'COUNTRY',

Line 312: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,

308: IF l_result is NOT NULL THEN
309: return l_result;
310: END IF;
311: l_product_code := fnd_profile.value('JGZZ_PRODUCT_CODE');
312: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
313: p_ledger_id => NULL,
314: p_inv_org_id => NULL,
315: p_resp_id => FND_GLOBAL.RESP_ID,
316: p_type => 'PRODUCT',

Line 357: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,

353: END IF;
354: END IF;
355: END IF;
356:
357: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,
358: p_ledger_id => p_ledger_id,
359: p_inv_org_id => p_inv_org_id,
360: p_resp_id => NULL,
361: p_type => 'PRODUCT',

Line 379: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,

375: IF l_result is NOT NULL THEN
376: return l_result;
377: END IF;
378: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
379: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
380: p_ledger_id => NULL,
381: p_inv_org_id => NULL,
382: p_resp_id => FND_GLOBAL.RESP_ID,
383: p_type => 'APPL',

Line 439: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,

435: return l_result;
436: END IF;
437:
438: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
439: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
440: p_ledger_id => NULL,
441: p_inv_org_id => NULL,
442: p_resp_id => FND_GLOBAL.RESP_ID,
443: p_type => 'APPL',

Line 451: END JG_ZZ_SHARED_PKG;

447: RETURN l_application;
448:
449: END get_application;
450:
451: END JG_ZZ_SHARED_PKG;