APPS.ARRX_COGS_REP_INNER dependencies on AR_COGS_REV_ITF

Line 66: l_description ar_cogs_rev_itf.cogs_acct_description%TYPE;

62:
63: PROCEDURE populate_description IS
64:
65: l_dummy BOOLEAN;
66: l_description ar_cogs_rev_itf.cogs_acct_description%TYPE;
67:
68: -- Please note that now description has code_combination_id
69: --
70: CURSOR getdesc IS

Line 73: FROM ar_cogs_rev_itf cgs, gl_code_combinations gcc

69: --
70: CURSOR getdesc IS
71: SELECT cgs.cogs_acct_description code_combination_id,
72: gcc.chart_of_accounts_id
73: FROM ar_cogs_rev_itf cgs, gl_code_combinations gcc
74: WHERE cgs.cogs_acct_description = gcc.code_combination_id;
75:
76: BEGIN
77:

Line 84: -- ar_cogs_rev_itf table. So, we are overloading the description

80: -- To get the description we need to call the function
81: -- fnd_flex_keyval.concatenated_descriptions however this will only
82: -- work if the cc id was validated just before that. To do that
83: -- we need the code_combination_id which is not stored in the
84: -- ar_cogs_rev_itf table. So, we are overloading the description
85: -- column temporariliy to store the code_combination_id and here
86: -- we will update it with the corresponding description.
87:
88: fnd_file.put_line(fnd_file.log, 'populate_description');

Line 102: UPDATE ar_cogs_rev_itf

98:
99: fnd_file.put_line(fnd_file.log, 'CC ID: ' || rec.code_combination_id);
100: fnd_file.put_line(fnd_file.log, 'Description: ' || l_description);
101:
102: UPDATE ar_cogs_rev_itf
103: SET cogs_acct_description = l_description
104: WHERE cogs_acct_description = rec.code_combination_id;
105:
106: END LOOP;

Line 163: DELETE FROM ar_cogs_rev_itf;

159: FETCH precision INTO l_precision;
160: CLOSE precision;
161:
162: -- start out with a fresh table.
163: DELETE FROM ar_cogs_rev_itf;
164:
165: -- respond to the user preference set in the program parameter.
166: -- if yes then exclude lines with posting control id of -3
167:

Line 177: INSERT INTO ar_cogs_rev_itf

173: fnd_file.put_line(fnd_file.log, 'table being populated with selected rows');
174:
175: -- the commented columns are populated later for better readability.
176:
177: INSERT INTO ar_cogs_rev_itf
178: (
179: request_id,
180: created_by,
181: creation_date,

Line 322: UPDATE ar_cogs_rev_itf

318: -- and actual adjustment needed separately here. the formula for
319: -- cogs adjustment is: (%rev - %cogs) * cogs_amount_orig
320: --
321:
322: UPDATE ar_cogs_rev_itf
323: SET rev_percent_period = ROUND((((rev_amount_period/order_amount_orig) *
324: DECODE(trx_class, 'CM', -100, 100))),
325: l_precision),
326: cogs_percent_period = ROUND(((cogs_amount_period/cogs_amount_orig)

Line 338: UPDATE ar_cogs_rev_itf

334:
335: -- Bug # 3840467
336: -- take care of null columns
337:
338: UPDATE ar_cogs_rev_itf
339: SET rev_percent_period = 0,
340: cogs_percent_period = 0,
341: cogs_adjustment = 0
342: WHERE cogs_amount_orig = 0

Line 353: DELETE FROM ar_cogs_rev_itf

349: -- preferred to do this here for better readability and maintainablity.
350:
351: IF p_unmatched_items_only = 'Y' THEN
352:
353: DELETE FROM ar_cogs_rev_itf
354: WHERE rev_percent_period = cogs_percent_period;
355:
356: fnd_file.put_line(fnd_file.log, 'deleting matched items');
357:

Line 416: FROM ar_cogs_rev_itf

412: CURSOR summary_rows IS
413: SELECT cogs_gl_account,
414: cogs_acct_description,
415: ROUND(SUM(cogs_adjustment), l_precision)
416: FROM ar_cogs_rev_itf
417: GROUP BY cogs_gl_account, cogs_acct_description;
418:
419: BEGIN
420:

Line 481: DELETE FROM ar_cogs_rev_itf;

477:
478: fnd_file.put_line(fnd_file.log, 'clearing detail rows from the table');
479:
480: -- remove the details rows and then populate summary rows.
481: DELETE FROM ar_cogs_rev_itf;
482:
483: fnd_file.put_line(fnd_file.log, 'summary rows count: ' ||
484: l_gl_acct_tbl.COUNT);
485:

Line 487: INSERT INTO ar_cogs_rev_itf

483: fnd_file.put_line(fnd_file.log, 'summary rows count: ' ||
484: l_gl_acct_tbl.COUNT);
485:
486: FORALL i IN 1..l_gl_acct_tbl.COUNT
487: INSERT INTO ar_cogs_rev_itf
488: (
489: request_id,
490: created_by,
491: creation_date,

Line 520: DELETE FROM ar_cogs_rev_itf

516: IF ((p_gl_account_low IS NOT NULL) OR (p_gl_account_low IS NOT NULL)) THEN
517:
518: fnd_file.put_line(fnd_file.log, 'keep only the rows within acct range');
519:
520: DELETE FROM ar_cogs_rev_itf
521: WHERE COGS_GL_ACCOUNT
522: NOT BETWEEN p_gl_account_low AND p_gl_account_high;
523:
524: END IF;