APPS.XLA_XLAABACR_XMLP_PKG dependencies on XLA_PRODUCT_RULES_B

Line 11: XLA_PRODUCT_RULES_B PRB

7: PRB.AMB_CONTEXT_CODE,
8: PRB.PRODUCT_RULE_TYPE_CODE,
9: PRB.PRODUCT_RULE_CODE
10: FROM
11: XLA_PRODUCT_RULES_B PRB
12: WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
13: ,'N'
14: ,'Y'
15: ,'') )

Line 27: XLA_PRODUCT_RULES_B PRB

23: PRB.AMB_CONTEXT_CODE,
24: PRB.PRODUCT_RULE_TYPE_CODE,
25: PRB.PRODUCT_RULE_CODE
26: FROM
27: XLA_PRODUCT_RULES_B PRB
28: WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
29: ,'N'
30: ,'Y'
31: ,'') )

Line 44: XLA_PRODUCT_RULES_B PRB

40: PRB.AMB_CONTEXT_CODE,
41: PRB.PRODUCT_RULE_TYPE_CODE,
42: PRB.PRODUCT_RULE_CODE
43: FROM
44: XLA_PRODUCT_RULES_B PRB
45: WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
46: ,'N'
47: ,'Y'
48: ,'') )

Line 62: XLA_PRODUCT_RULES_B PRB,

58: PRB.AMB_CONTEXT_CODE,
59: PRB.PRODUCT_RULE_TYPE_CODE,
60: PRB.PRODUCT_RULE_CODE
61: FROM
62: XLA_PRODUCT_RULES_B PRB,
63: XLA_GL_LEDGERS_V LE,
64: XLA_ACCTG_METHOD_RULES AMR,
65: XLA_LEDGER_RELATIONSHIPS_V LR
66: WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE

Line 90: XLA_PRODUCT_RULES_B PRB,

86: PRB.AMB_CONTEXT_CODE,
87: PRB.PRODUCT_RULE_TYPE_CODE,
88: PRB.PRODUCT_RULE_CODE
89: FROM
90: XLA_PRODUCT_RULES_B PRB,
91: XLA_GL_LEDGERS_V LE,
92: XLA_ACCTG_METHOD_RULES AMR
93: WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
94: AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE

Line 145: XLA_PRODUCT_RULES_B

141: ,30);
142: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
143: ,30);
144: UPDATE
145: XLA_PRODUCT_RULES_B
146: SET
147: COMPILE_STATUS_CODE = 'R'
148: WHERE APPLICATION_ID = L_APPLICATION_ID
149: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 166: XLA_PRODUCT_RULES_B

162: ELSE
163: L_COMPILE_STATUS_CODE := 'Y';
164: END IF;
165: UPDATE
166: XLA_PRODUCT_RULES_B
167: SET
168: COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
169: WHERE APPLICATION_ID = L_APPLICATION_ID
170: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 196: XLA_PRODUCT_RULES_B

192: ,30);
193: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
194: ,30);
195: UPDATE
196: XLA_PRODUCT_RULES_B
197: SET
198: COMPILE_STATUS_CODE = 'R'
199: WHERE APPLICATION_ID = L_APPLICATION_ID
200: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 217: XLA_PRODUCT_RULES_B

213: ELSE
214: L_COMPILE_STATUS_CODE := 'Y';
215: END IF;
216: UPDATE
217: XLA_PRODUCT_RULES_B
218: SET
219: COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
220: WHERE APPLICATION_ID = L_APPLICATION_ID
221: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 247: XLA_PRODUCT_RULES_B

243: ,30);
244: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
245: ,30);
246: UPDATE
247: XLA_PRODUCT_RULES_B
248: SET
249: COMPILE_STATUS_CODE = 'R'
250: WHERE APPLICATION_ID = L_APPLICATION_ID
251: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 268: XLA_PRODUCT_RULES_B

264: ELSE
265: L_COMPILE_STATUS_CODE := 'Y';
266: END IF;
267: UPDATE
268: XLA_PRODUCT_RULES_B
269: SET
270: COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
271: WHERE APPLICATION_ID = L_APPLICATION_ID
272: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 300: XLA_PRODUCT_RULES_B

296: ,30);
297: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
298: ,30);
299: UPDATE
300: XLA_PRODUCT_RULES_B
301: SET
302: COMPILE_STATUS_CODE = 'R'
303: WHERE APPLICATION_ID = L_APPLICATION_ID
304: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 321: XLA_PRODUCT_RULES_B

317: ELSE
318: L_COMPILE_STATUS_CODE := 'Y';
319: END IF;
320: UPDATE
321: XLA_PRODUCT_RULES_B
322: SET
323: COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
324: WHERE APPLICATION_ID = L_APPLICATION_ID
325: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 351: XLA_PRODUCT_RULES_B

347: ,30);
348: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
349: ,30);
350: UPDATE
351: XLA_PRODUCT_RULES_B
352: SET
353: COMPILE_STATUS_CODE = 'R'
354: WHERE APPLICATION_ID = L_APPLICATION_ID
355: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE

Line 372: XLA_PRODUCT_RULES_B

368: ELSE
369: L_COMPILE_STATUS_CODE := 'Y';
370: END IF;
371: UPDATE
372: XLA_PRODUCT_RULES_B
373: SET
374: COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
375: WHERE APPLICATION_ID = L_APPLICATION_ID
376: AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE