APPS.AR_RAXNCAR_XMLP_PKG dependencies on AR_RAXNCAR_XMLP_PKG

Line 1: PACKAGE BODY AR_RAXNCAR_XMLP_PKG AS

1: PACKAGE BODY AR_RAXNCAR_XMLP_PKG AS
2: /* $Header: RAXNCARB.pls 120.0 2007/12/27 14:31:08 abraghun noship $ */
3:
4: function report_nameformula(Company_Name in varchar2) return varchar2 is
5: begin

Line 93: AR_RAXNCAR_XMLP_PKG.yes := yes;

89: AND
90: INV.LOOKUP_TYPE = 'INV/CM' AND
91: INV.LOOKUP_CODE = 'INV';
92:
93: AR_RAXNCAR_XMLP_PKG.yes := yes;
94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;

Line 94: AR_RAXNCAR_XMLP_PKG.no := no;

90: INV.LOOKUP_TYPE = 'INV/CM' AND
91: INV.LOOKUP_CODE = 'INV';
92:
93: AR_RAXNCAR_XMLP_PKG.yes := yes;
94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;
98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;

Line 95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;

91: INV.LOOKUP_CODE = 'INV';
92:
93: AR_RAXNCAR_XMLP_PKG.yes := yes;
94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;
98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;
99:

Line 96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;

92:
93: AR_RAXNCAR_XMLP_PKG.yes := yes;
94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;
98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;
99:
100:

Line 97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;

93: AR_RAXNCAR_XMLP_PKG.yes := yes;
94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;
98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;
99:
100:
101:

Line 98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;

94: AR_RAXNCAR_XMLP_PKG.no := no;
95: AR_RAXNCAR_XMLP_PKG.cm_foot := cm_foot;
96: AR_RAXNCAR_XMLP_PKG.dep_foot := dep_foot;
97: AR_RAXNCAR_XMLP_PKG.guar_foot := guar_foot;
98: AR_RAXNCAR_XMLP_PKG.inv_foot := inv_foot;
99:
100:
101:
102: SELECT TO_CHAR(MIN(GL_DATE), 'DD-MON-YYYY') arra_min,

Line 108: AR_RAXNCAR_XMLP_PKG.arra_min := arra_min;

104: INTO arra_min,
105: arra_max
106: FROM AR_RECEIVABLE_APPLICATIONS;
107:
108: AR_RAXNCAR_XMLP_PKG.arra_min := arra_min;
109: AR_RAXNCAR_XMLP_PKG.arra_max := arra_max;
110:
111: SELECT TO_CHAR(MIN(GL_DATE), 'DD-MON-YYYY') adjs_min,
112: TO_CHAR(MAX(GL_DATE), 'DD-MON-YYYY') adjs_max

Line 109: AR_RAXNCAR_XMLP_PKG.arra_max := arra_max;

105: arra_max
106: FROM AR_RECEIVABLE_APPLICATIONS;
107:
108: AR_RAXNCAR_XMLP_PKG.arra_min := arra_min;
109: AR_RAXNCAR_XMLP_PKG.arra_max := arra_max;
110:
111: SELECT TO_CHAR(MIN(GL_DATE), 'DD-MON-YYYY') adjs_min,
112: TO_CHAR(MAX(GL_DATE), 'DD-MON-YYYY') adjs_max
113: INTO adjs_min,

Line 117: AR_RAXNCAR_XMLP_PKG.adjs_min := adjs_min;

113: INTO adjs_min,
114: adjs_max
115: FROM AR_ADJUSTMENTS;
116:
117: AR_RAXNCAR_XMLP_PKG.adjs_min := adjs_min;
118: AR_RAXNCAR_XMLP_PKG.adjs_max := adjs_max;
119:
120: SELECT TO_CHAR(LEAST(TO_DATE(arra_min, 'DD-MM-YYYY'), TO_DATE(adjs_min, 'DD-MM-YYYY')),'DD-MM-YYYY') min_date,
121: TO_CHAR(GREATEST(TO_DATE(arra_max, 'DD-MM-YYYY'),TO_DATE(adjs_max, 'DD-MM-YYYY')),'DD-MM-YYYY') max_date

Line 118: AR_RAXNCAR_XMLP_PKG.adjs_max := adjs_max;

114: adjs_max
115: FROM AR_ADJUSTMENTS;
116:
117: AR_RAXNCAR_XMLP_PKG.adjs_min := adjs_min;
118: AR_RAXNCAR_XMLP_PKG.adjs_max := adjs_max;
119:
120: SELECT TO_CHAR(LEAST(TO_DATE(arra_min, 'DD-MM-YYYY'), TO_DATE(adjs_min, 'DD-MM-YYYY')),'DD-MM-YYYY') min_date,
121: TO_CHAR(GREATEST(TO_DATE(arra_max, 'DD-MM-YYYY'),TO_DATE(adjs_max, 'DD-MM-YYYY')),'DD-MM-YYYY') max_date
122: INTO

Line 127: AR_RAXNCAR_XMLP_PKG.min_date := min_date;

123: min_date,
124: max_date
125: FROM DUAL;
126:
127: AR_RAXNCAR_XMLP_PKG.min_date := min_date;
128: AR_RAXNCAR_XMLP_PKG.max_date := max_date;
129:
130: SELECT DECODE(TO_CHAR(p_start_gl_date, 'DD-MON-YYYY'),
131: NULL, min_date,

Line 128: AR_RAXNCAR_XMLP_PKG.max_date := max_date;

124: max_date
125: FROM DUAL;
126:
127: AR_RAXNCAR_XMLP_PKG.min_date := min_date;
128: AR_RAXNCAR_XMLP_PKG.max_date := max_date;
129:
130: SELECT DECODE(TO_CHAR(p_start_gl_date, 'DD-MON-YYYY'),
131: NULL, min_date,
132: TO_CHAR(p_start_gl_date, 'DD-MON-YYYY')) sql_start_date,

Line 141: AR_RAXNCAR_XMLP_PKG.sql_start_date := sql_start_date;

137: sql_start_date,
138: sql_end_date
139: FROM DUAL;
140:
141: AR_RAXNCAR_XMLP_PKG.sql_start_date := sql_start_date;
142: AR_RAXNCAR_XMLP_PKG.sql_end_date := sql_end_date;
143:
144: end;
145:

Line 142: AR_RAXNCAR_XMLP_PKG.sql_end_date := sql_end_date;

138: sql_end_date
139: FROM DUAL;
140:
141: AR_RAXNCAR_XMLP_PKG.sql_start_date := sql_start_date;
142: AR_RAXNCAR_XMLP_PKG.sql_end_date := sql_end_date;
143:
144: end;
145:
146:

Line 257: END AR_RAXNCAR_XMLP_PKG ;

253: begin
254: RP_DATA_FOUND:='X';
255: return null;
256: end;
257: END AR_RAXNCAR_XMLP_PKG ;
258:
259: