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.20.12020000.4 2012/08/03 06:51:39 abhijsar ship $ */
3:
4: FUNCTION IS_GLOBALIZATION_ENABLED(p_country_code IN VARCHAR2)
5: RETURN VARCHAR2 IS

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

45: RETURN VARCHAR2 IS
46: BEGIN
47: IF p_org_id is NOT NULL THEN
48: IF p_type = 'COUNTRY' THEN
49: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
50: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
51: END IF;
52: ELSIF p_type = 'PRODUCT' THEN
53: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN

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

46: BEGIN
47: IF p_org_id is NOT NULL THEN
48: IF p_type = 'COUNTRY' THEN
49: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
50: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
51: END IF;
52: ELSIF p_type = 'PRODUCT' THEN
53: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
54: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));

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

49: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('ORGID'||to_char(p_org_id)) THEN
50: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
51: END IF;
52: ELSIF p_type = 'PRODUCT' THEN
53: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
54: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
55: END IF;
56: ELSIF p_type = 'APPL' THEN
57: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN

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

50: return JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id));
51: END IF;
52: ELSIF p_type = 'PRODUCT' THEN
53: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
54: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
55: END IF;
56: ELSIF p_type = 'APPL' THEN
57: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
58: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));

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

53: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('ORGID'||to_char(p_org_id)) THEN
54: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
55: END IF;
56: ELSIF p_type = 'APPL' THEN
57: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
58: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));
59: END IF;
60: END IF;
61:

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

54: return JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id));
55: END IF;
56: ELSIF p_type = 'APPL' THEN
57: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('ORGID'||to_char(p_org_id)) THEN
58: return JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id));
59: END IF;
60: END IF;
61:
62: ELSIF p_ledger_id is NOT NULL THEN

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

60: END IF;
61:
62: ELSIF p_ledger_id is NOT NULL THEN
63: IF p_type = 'COUNTRY' THEN
64: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
65: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
66: END IF;
67: ELSIF p_type = 'PRODUCT' THEN
68: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

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

61:
62: ELSIF p_ledger_id is NOT NULL THEN
63: IF p_type = 'COUNTRY' THEN
64: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
65: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
66: END IF;
67: ELSIF p_type = 'PRODUCT' THEN
68: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
69: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));

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

64: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
65: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
66: END IF;
67: ELSIF p_type = 'PRODUCT' THEN
68: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
69: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
70: END IF;
71: ELSIF p_type = 'APPL' THEN
72: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN

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

65: return JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id));
66: END IF;
67: ELSIF p_type = 'PRODUCT' THEN
68: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
69: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
70: END IF;
71: ELSIF p_type = 'APPL' THEN
72: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
73: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));

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

68: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
69: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
70: END IF;
71: ELSIF p_type = 'APPL' THEN
72: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
73: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));
74: END IF;
75: END IF;
76:

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

69: return JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id));
70: END IF;
71: ELSIF p_type = 'APPL' THEN
72: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('LEID'||to_char(p_ledger_id)) THEN
73: return JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id));
74: END IF;
75: END IF;
76:
77: ELSIF p_inv_org_id is NOT NULL THEN

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

75: END IF;
76:
77: ELSIF p_inv_org_id is NOT NULL THEN
78: IF p_type = 'COUNTRY' THEN
79: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
80: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
81: END IF;
82: ELSIF p_type = 'PRODUCT' THEN
83: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

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

76:
77: ELSIF p_inv_org_id is NOT NULL THEN
78: IF p_type = 'COUNTRY' THEN
79: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
80: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
81: END IF;
82: ELSIF p_type = 'PRODUCT' THEN
83: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
84: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));

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

79: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
80: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
81: END IF;
82: ELSIF p_type = 'PRODUCT' THEN
83: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
84: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
85: END IF;
86: ELSIF p_type = 'APPL' THEN
87: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN

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

80: return JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id));
81: END IF;
82: ELSIF p_type = 'PRODUCT' THEN
83: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
84: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
85: END IF;
86: ELSIF p_type = 'APPL' THEN
87: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
88: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));

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

83: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
84: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
85: END IF;
86: ELSIF p_type = 'APPL' THEN
87: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
88: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));
89: END IF;
90: END IF;
91:

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

84: return JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id));
85: END IF;
86: ELSIF p_type = 'APPL' THEN
87: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('INVID'||to_char(p_inv_org_id)) THEN
88: return JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id));
89: END IF;
90: END IF;
91:
92: ELSIF p_resp_id is NOT NULL THEN

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

90: END IF;
91:
92: ELSIF p_resp_id is NOT NULL THEN
93: IF p_type = 'COUNTRY' THEN
94: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
95: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
96: END IF;
97: ELSIF p_type = 'PRODUCT' THEN
98: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

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

91:
92: ELSIF p_resp_id is NOT NULL THEN
93: IF p_type = 'COUNTRY' THEN
94: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
95: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
96: END IF;
97: ELSIF p_type = 'PRODUCT' THEN
98: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
99: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));

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

94: IF JG_ZZ_SHARED_PKG.p_country_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
95: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
96: END IF;
97: ELSIF p_type = 'PRODUCT' THEN
98: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
99: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
100: END IF;
101: ELSIF p_type = 'APPL' THEN
102: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN

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

95: return JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id));
96: END IF;
97: ELSIF p_type = 'PRODUCT' THEN
98: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
99: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
100: END IF;
101: ELSIF p_type = 'APPL' THEN
102: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
103: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));

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

98: IF JG_ZZ_SHARED_PKG.p_product_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
99: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
100: END IF;
101: ELSIF p_type = 'APPL' THEN
102: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
103: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));
104: END IF;
105: END IF;
106:

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

99: return JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id));
100: END IF;
101: ELSIF p_type = 'APPL' THEN
102: IF JG_ZZ_SHARED_PKG.p_appl_tbl.exists('RESPID'||to_char(p_resp_id)) THEN
103: return JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id));
104: END IF;
105: END IF;
106:
107: END IF;

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

118: IS
119: BEGIN
120: IF p_org_id is NOT NULL THEN
121: IF p_type = 'COUNTRY' THEN
122: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
123: ELSIF p_type = 'PRODUCT' THEN
124: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
125: ELSIF p_type = 'APPL' THEN
126: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;

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

120: IF p_org_id is NOT NULL THEN
121: IF p_type = 'COUNTRY' THEN
122: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
123: ELSIF p_type = 'PRODUCT' THEN
124: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
125: ELSIF p_type = 'APPL' THEN
126: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;
127: END IF;
128:

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

122: JG_ZZ_SHARED_PKG.p_country_tbl('ORGID'||to_char(p_org_id)) := p_value;
123: ELSIF p_type = 'PRODUCT' THEN
124: JG_ZZ_SHARED_PKG.p_product_tbl('ORGID'||to_char(p_org_id)) := p_value;
125: ELSIF p_type = 'APPL' THEN
126: JG_ZZ_SHARED_PKG.p_appl_tbl('ORGID'||to_char(p_org_id)) := p_value;
127: END IF;
128:
129: ELSIF p_ledger_id is NOT NULL THEN
130: IF p_type = 'COUNTRY' THEN

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

127: END IF;
128:
129: ELSIF p_ledger_id is NOT NULL THEN
130: IF p_type = 'COUNTRY' THEN
131: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
132: ELSIF p_type = 'PRODUCT' THEN
133: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
134: ELSIF p_type = 'APPL' THEN
135: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;

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

129: ELSIF p_ledger_id is NOT NULL THEN
130: IF p_type = 'COUNTRY' THEN
131: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
132: ELSIF p_type = 'PRODUCT' THEN
133: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
134: ELSIF p_type = 'APPL' THEN
135: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;
136: END IF;
137:

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

131: JG_ZZ_SHARED_PKG.p_country_tbl('LEID'||to_char(p_ledger_id)) := p_value;
132: ELSIF p_type = 'PRODUCT' THEN
133: JG_ZZ_SHARED_PKG.p_product_tbl('LEID'||to_char(p_ledger_id)) := p_value;
134: ELSIF p_type = 'APPL' THEN
135: JG_ZZ_SHARED_PKG.p_appl_tbl('LEID'||to_char(p_ledger_id)) := p_value;
136: END IF;
137:
138: ELSIF p_inv_org_id is NOT NULL THEN
139: IF p_type = 'COUNTRY' THEN

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

136: END IF;
137:
138: ELSIF p_inv_org_id is NOT NULL THEN
139: IF p_type = 'COUNTRY' THEN
140: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
141: ELSIF p_type = 'PRODUCT' THEN
142: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
143: ELSIF p_type = 'APPL' THEN
144: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;

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

138: ELSIF p_inv_org_id is NOT NULL THEN
139: IF p_type = 'COUNTRY' THEN
140: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
141: ELSIF p_type = 'PRODUCT' THEN
142: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
143: ELSIF p_type = 'APPL' THEN
144: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
145: END IF;
146:

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

140: JG_ZZ_SHARED_PKG.p_country_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
141: ELSIF p_type = 'PRODUCT' THEN
142: JG_ZZ_SHARED_PKG.p_product_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
143: ELSIF p_type = 'APPL' THEN
144: JG_ZZ_SHARED_PKG.p_appl_tbl('INVID'||to_char(p_inv_org_id)) := p_value;
145: END IF;
146:
147: ELSIF p_resp_id is NOT NULL THEN
148: IF p_type = 'COUNTRY' THEN

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

145: END IF;
146:
147: ELSIF p_resp_id is NOT NULL THEN
148: IF p_type = 'COUNTRY' THEN
149: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
150: ELSIF p_type = 'PRODUCT' THEN
151: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
152: ELSIF p_type = 'APPL' THEN
153: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;

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

147: ELSIF p_resp_id is NOT NULL THEN
148: IF p_type = 'COUNTRY' THEN
149: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
150: ELSIF p_type = 'PRODUCT' THEN
151: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
152: ELSIF p_type = 'APPL' THEN
153: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;
154: END IF;
155: END IF;

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

149: JG_ZZ_SHARED_PKG.p_country_tbl('RESPID'||to_char(p_resp_id)) := p_value;
150: ELSIF p_type = 'PRODUCT' THEN
151: JG_ZZ_SHARED_PKG.p_product_tbl('RESPID'||to_char(p_resp_id)) := p_value;
152: ELSIF p_type = 'APPL' THEN
153: JG_ZZ_SHARED_PKG.p_appl_tbl('RESPID'||to_char(p_resp_id)) := p_value;
154: END IF;
155: END IF;
156:
157: END PUT_CACHE;

Line 167: l_result := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_result);

163: l_result VARCHAR2(10);
164: BEGIN
165:
166: l_result := CHECK_CACHE(NULL,NULL,NULL,FND_GLOBAL.RESP_ID,'COUNTRY') ;
167: l_result := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_result);
168:
169: IF l_result is NOT NULL THEN
170: return l_result;
171: END IF;

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

170: return l_result;
171: END IF;
172: l_country_code := fnd_profile.value('JGZZ_COUNTRY_CODE');
173:
174: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
175: p_ledger_id => NULL,
176: p_inv_org_id => NULL,
177: p_resp_id => FND_GLOBAL.RESP_ID,
178: p_type => 'COUNTRY',

Line 180: l_country_code := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_country_code);

176: p_inv_org_id => NULL,
177: p_resp_id => FND_GLOBAL.RESP_ID,
178: p_type => 'COUNTRY',
179: p_value => l_country_code);
180: l_country_code := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_country_code);
181:
182: return l_country_code;
183:
184: END get_country;

Line 204: l_result := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_result);

200: BEGIN
201:
202: l_result := NULL;
203: l_result := CHECK_CACHE(p_org_id,p_ledger_id,p_inv_org_id,NULL,'COUNTRY');
204: l_result := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_result);
205:
206: IF l_result is NOT NULL THEN
207: return l_result;
208: END IF;

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

327: l_country_code := l_Inv_Le_info_rec(l_Inv_Le_info_rec.FIRST).COUNTRY;
328: END IF;
329:
330: END IF;
331: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,
332: p_ledger_id => p_ledger_id,
333: p_inv_org_id => p_inv_org_id,
334: p_resp_id => NULL,
335: p_type => 'COUNTRY',

Line 338: l_country_code := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_country_code);

334: p_resp_id => NULL,
335: p_type => 'COUNTRY',
336: p_value => l_country_code);
337:
338: l_country_code := JG_ZZ_SHARED_PKG.IS_GLOBALIZATION_ENABLED(l_country_code);
339:
340: return l_country_code;
341:
342: END get_country;

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

351: IF l_result is NOT NULL THEN
352: return l_result;
353: END IF;
354: l_product_code := fnd_profile.value('JGZZ_PRODUCT_CODE');
355: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
356: p_ledger_id => NULL,
357: p_inv_org_id => NULL,
358: p_resp_id => FND_GLOBAL.RESP_ID,
359: p_type => 'PRODUCT',

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

397: END IF;
398: END IF;
399: END IF;
400:
401: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => p_org_id,
402: p_ledger_id => p_ledger_id,
403: p_inv_org_id => p_inv_org_id,
404: p_resp_id => NULL,
405: p_type => 'PRODUCT',

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

419: IF l_result is NOT NULL THEN
420: return l_result;
421: END IF;
422: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
423: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
424: p_ledger_id => NULL,
425: p_inv_org_id => NULL,
426: p_resp_id => FND_GLOBAL.RESP_ID,
427: p_type => 'APPL',

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

479: return l_result;
480: END IF;
481:
482: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
483: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
484: p_ledger_id => NULL,
485: p_inv_org_id => NULL,
486: p_resp_id => FND_GLOBAL.RESP_ID,
487: p_type => 'APPL',

Line 495: END JG_ZZ_SHARED_PKG;

491: RETURN l_application;
492:
493: END get_application;
494:
495: END JG_ZZ_SHARED_PKG;