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.GCS_RULES_PROCESSOR dependencies on DBMS_SQL

Line 559: l_entities DBMS_SQL.number_table;

555: SELECT target_entity_code, net_to_re_flag
556: FROM gcs_categories_b
557: WHERE category_code = contextData.eventCategory;
558:
559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;

Line 560: l_percent DBMS_SQL.number_table;

556: FROM gcs_categories_b
557: WHERE category_code = contextData.eventCategory;
558:
559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;
564: l_flag DBMS_SQL.varchar2_table;

Line 561: l_precision DBMS_SQL.number_table;

557: WHERE category_code = contextData.eventCategory;
558:
559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;
564: l_flag DBMS_SQL.varchar2_table;
565:

Line 562: l_seq DBMS_SQL.number_table;

558:
559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;
564: l_flag DBMS_SQL.varchar2_table;
565:
566: l_end_date DATE;

Line 563: l_currency DBMS_SQL.varchar2_table;

559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;
564: l_flag DBMS_SQL.varchar2_table;
565:
566: l_end_date DATE;
567: l_rate_var NUMBER;

Line 564: l_flag DBMS_SQL.varchar2_table;

560: l_percent DBMS_SQL.number_table;
561: l_precision DBMS_SQL.number_table;
562: l_seq DBMS_SQL.number_table;
563: l_currency DBMS_SQL.varchar2_table;
564: l_flag DBMS_SQL.varchar2_table;
565:
566: l_end_date DATE;
567: l_rate_var NUMBER;
568: l_ccyPrecision NUMBER;

Line 2204: entriesStmtIdx integer := dbms_sql.open_cursor;

2200: childEntityToken boolean := false;
2201: miToken boolean := false;
2202: ownToken boolean := false;
2203: bindVarIndex varchar2(30);
2204: entriesStmtIdx integer := dbms_sql.open_cursor;
2205: outputStmtIdx integer := dbms_sql.open_cursor;
2206: dbmsSqlVal number;
2207: rowcount number;
2208: outputStmt varchar2(1000);

Line 2205: outputStmtIdx integer := dbms_sql.open_cursor;

2201: miToken boolean := false;
2202: ownToken boolean := false;
2203: bindVarIndex varchar2(30);
2204: entriesStmtIdx integer := dbms_sql.open_cursor;
2205: outputStmtIdx integer := dbms_sql.open_cursor;
2206: dbmsSqlVal number;
2207: rowcount number;
2208: outputStmt varchar2(1000);
2209: setOutput varchar2(100);

Line 2545: dbms_sql.parse(entriesStmtIdx, entriesStmt, DBMS_SQL.NATIVE);

2541:
2542: --=======================================================
2543: logString(eventLogLevel, procedureName, 'section', '5');
2544: --=======================================================
2545: dbms_sql.parse(entriesStmtIdx, entriesStmt, DBMS_SQL.NATIVE);
2546: dbms_sql.bind_variable(entriesStmtIdx,
2547: 'rid',
2548: stepData(stepSeq).rule_id);
2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);

Line 2546: dbms_sql.bind_variable(entriesStmtIdx,

2542: --=======================================================
2543: logString(eventLogLevel, procedureName, 'section', '5');
2544: --=======================================================
2545: dbms_sql.parse(entriesStmtIdx, entriesStmt, DBMS_SQL.NATIVE);
2546: dbms_sql.bind_variable(entriesStmtIdx,
2547: 'rid',
2548: stepData(stepSeq).rule_id);
2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);
2550: dbms_sql.bind_variable(entriesStmtIdx,

Line 2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);

2545: dbms_sql.parse(entriesStmtIdx, entriesStmt, DBMS_SQL.NATIVE);
2546: dbms_sql.bind_variable(entriesStmtIdx,
2547: 'rid',
2548: stepData(stepSeq).rule_id);
2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);
2550: dbms_sql.bind_variable(entriesStmtIdx,
2551: 'sna',
2552: stepData(stepSeq).step_name);
2553: dbms_sql.bind_variable(entriesStmtIdx,

Line 2550: dbms_sql.bind_variable(entriesStmtIdx,

2546: dbms_sql.bind_variable(entriesStmtIdx,
2547: 'rid',
2548: stepData(stepSeq).rule_id);
2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);
2550: dbms_sql.bind_variable(entriesStmtIdx,
2551: 'sna',
2552: stepData(stepSeq).step_name);
2553: dbms_sql.bind_variable(entriesStmtIdx,
2554: 'ftx',

Line 2553: dbms_sql.bind_variable(entriesStmtIdx,

2549: dbms_sql.bind_variable(entriesStmtIdx, 'seq', stepSeq);
2550: dbms_sql.bind_variable(entriesStmtIdx,
2551: 'sna',
2552: stepData(stepSeq).step_name);
2553: dbms_sql.bind_variable(entriesStmtIdx,
2554: 'ftx',
2555: stepData(stepSeq).formula_text);
2556: dbms_sql.bind_variable(entriesStmtIdx, 'rsi', ruleStepId);
2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);

Line 2556: dbms_sql.bind_variable(entriesStmtIdx, 'rsi', ruleStepId);

2552: stepData(stepSeq).step_name);
2553: dbms_sql.bind_variable(entriesStmtIdx,
2554: 'ftx',
2555: stepData(stepSeq).formula_text);
2556: dbms_sql.bind_variable(entriesStmtIdx, 'rsi', ruleStepId);
2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);
2558: dbms_sql.bind_variable(entriesStmtIdx,
2559: 'stn',
2560: stepData(stepSeq).sql_statement_num);

Line 2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);

2553: dbms_sql.bind_variable(entriesStmtIdx,
2554: 'ftx',
2555: stepData(stepSeq).formula_text);
2556: dbms_sql.bind_variable(entriesStmtIdx, 'rsi', ruleStepId);
2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);
2558: dbms_sql.bind_variable(entriesStmtIdx,
2559: 'stn',
2560: stepData(stepSeq).sql_statement_num);
2561: dbms_sql.bind_variable(entriesStmtIdx,

Line 2558: dbms_sql.bind_variable(entriesStmtIdx,

2554: 'ftx',
2555: stepData(stepSeq).formula_text);
2556: dbms_sql.bind_variable(entriesStmtIdx, 'rsi', ruleStepId);
2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);
2558: dbms_sql.bind_variable(entriesStmtIdx,
2559: 'stn',
2560: stepData(stepSeq).sql_statement_num);
2561: dbms_sql.bind_variable(entriesStmtIdx,
2562: 'dci',

Line 2561: dbms_sql.bind_variable(entriesStmtIdx,

2557: dbms_sql.bind_variable(entriesStmtIdx, 'osf', offsetFlag);
2558: dbms_sql.bind_variable(entriesStmtIdx,
2559: 'stn',
2560: stepData(stepSeq).sql_statement_num);
2561: dbms_sql.bind_variable(entriesStmtIdx,
2562: 'dci',
2563: contextData.datasetCode);
2564: dbms_sql.bind_variable(entriesStmtIdx,
2565: 'cpi',

Line 2564: dbms_sql.bind_variable(entriesStmtIdx,

2560: stepData(stepSeq).sql_statement_num);
2561: dbms_sql.bind_variable(entriesStmtIdx,
2562: 'dci',
2563: contextData.datasetCode);
2564: dbms_sql.bind_variable(entriesStmtIdx,
2565: 'cpi',
2566: contextData.calPeriodId);
2567: dbms_sql.bind_variable(entriesStmtIdx,
2568: 'ccy',

Line 2567: dbms_sql.bind_variable(entriesStmtIdx,

2563: contextData.datasetCode);
2564: dbms_sql.bind_variable(entriesStmtIdx,
2565: 'cpi',
2566: contextData.calPeriodId);
2567: dbms_sql.bind_variable(entriesStmtIdx,
2568: 'ccy',
2569: contextData.currencyCode);
2570: dbms_sql.bind_variable(entriesStmtIdx,
2571: 'tgt_cctr_org_id',

Line 2570: dbms_sql.bind_variable(entriesStmtIdx,

2566: contextData.calPeriodId);
2567: dbms_sql.bind_variable(entriesStmtIdx,
2568: 'ccy',
2569: contextData.currencyCode);
2570: dbms_sql.bind_variable(entriesStmtIdx,
2571: 'tgt_cctr_org_id',
2572: organizationId);
2573: dbms_sql.bind_variable(entriesStmtIdx,
2574: 'tgt_intercompany_id',

Line 2573: dbms_sql.bind_variable(entriesStmtIdx,

2569: contextData.currencyCode);
2570: dbms_sql.bind_variable(entriesStmtIdx,
2571: 'tgt_cctr_org_id',
2572: organizationId);
2573: dbms_sql.bind_variable(entriesStmtIdx,
2574: 'tgt_intercompany_id',
2575: intercompanyId);
2576: dbms_sql.bind_variable(entriesStmtIdx,
2577: 'eid',

Line 2576: dbms_sql.bind_variable(entriesStmtIdx,

2572: organizationId);
2573: dbms_sql.bind_variable(entriesStmtIdx,
2574: 'tgt_intercompany_id',
2575: intercompanyId);
2576: dbms_sql.bind_variable(entriesStmtIdx,
2577: 'eid',
2578: contextData.elimsEntity);
2579: dbms_sql.bind_variable(entriesStmtIdx,
2580: 'cid',

Line 2579: dbms_sql.bind_variable(entriesStmtIdx,

2575: intercompanyId);
2576: dbms_sql.bind_variable(entriesStmtIdx,
2577: 'eid',
2578: contextData.elimsEntity);
2579: dbms_sql.bind_variable(entriesStmtIdx,
2580: 'cid',
2581: contextData.childEntity);
2582: dbms_sql.bind_variable(entriesStmtIdx,
2583: 'pid',

Line 2582: dbms_sql.bind_variable(entriesStmtIdx,

2578: contextData.elimsEntity);
2579: dbms_sql.bind_variable(entriesStmtIdx,
2580: 'cid',
2581: contextData.childEntity);
2582: dbms_sql.bind_variable(entriesStmtIdx,
2583: 'pid',
2584: contextData.parentEntity);
2585: --Bugfix 5456211: Added ledger to the bind variables for performance purposes
2586: dbms_sql.bind_variable(entriesStmtIdx,

Line 2586: dbms_sql.bind_variable(entriesStmtIdx,

2582: dbms_sql.bind_variable(entriesStmtIdx,
2583: 'pid',
2584: contextData.parentEntity);
2585: --Bugfix 5456211: Added ledger to the bind variables for performance purposes
2586: dbms_sql.bind_variable(entriesStmtIdx,
2587: 'ledger',
2588: contextData.ledgerId);
2589:
2590: logString(statementLogLevel,

Line 2604: dbms_sql.bind_variable(entriesStmtIdx,

2600: logString(statementLogLevel,
2601: procedureName,
2602: 'bindVarinfo',
2603: bindVarinfo(bindVarIndex));
2604: dbms_sql.bind_variable(entriesStmtIdx,
2605: bindVarIndex,
2606: bindVarInfo(bindVarIndex));
2607: bindVarIndex := bindVarInfo.next(bindVarIndex);
2608: end loop;

Line 2615: dbmsSqlVal := dbms_sql.execute(entriesStmtIdx);

2611: procedureName,
2612: 'binding',
2613: 'completed binding variables');
2614:
2615: dbmsSqlVal := dbms_sql.execute(entriesStmtIdx);
2616:
2617: dbms_sql.close_cursor(entriesStmtIdx);
2618:
2619: setOutput := stepData(stepSeq).formula_text;

Line 2617: dbms_sql.close_cursor(entriesStmtIdx);

2613: 'completed binding variables');
2614:
2615: dbmsSqlVal := dbms_sql.execute(entriesStmtIdx);
2616:
2617: dbms_sql.close_cursor(entriesStmtIdx);
2618:
2619: setOutput := stepData(stepSeq).formula_text;
2620: if (INSTR(setOutput, 'CHILDTB') <> 0) then
2621: setOutput := replace(setOutput, 'CHILDTB', 'ce_input_amount');

Line 2646: dbms_sql.parse(outputStmtIdx, outputStmt, DBMS_SQL.NATIVE);

2642: ') / :currPrecision) * :currPrecision
2643: WHERE rule_id = :rule_id
2644: AND step_seq = :seq';
2645:
2646: dbms_sql.parse(outputStmtIdx, outputStmt, DBMS_SQL.NATIVE);
2647: dbms_sql.bind_variable(outputStmtIdx,
2648: 'rule_id',
2649: stepData(stepSeq).rule_id);
2650: dbms_sql.bind_variable(outputStmtIdx, 'seq', stepSeq);

Line 2647: dbms_sql.bind_variable(outputStmtIdx,

2643: WHERE rule_id = :rule_id
2644: AND step_seq = :seq';
2645:
2646: dbms_sql.parse(outputStmtIdx, outputStmt, DBMS_SQL.NATIVE);
2647: dbms_sql.bind_variable(outputStmtIdx,
2648: 'rule_id',
2649: stepData(stepSeq).rule_id);
2650: dbms_sql.bind_variable(outputStmtIdx, 'seq', stepSeq);
2651: dbms_sql.bind_variable(outputStmtIdx,

Line 2650: dbms_sql.bind_variable(outputStmtIdx, 'seq', stepSeq);

2646: dbms_sql.parse(outputStmtIdx, outputStmt, DBMS_SQL.NATIVE);
2647: dbms_sql.bind_variable(outputStmtIdx,
2648: 'rule_id',
2649: stepData(stepSeq).rule_id);
2650: dbms_sql.bind_variable(outputStmtIdx, 'seq', stepSeq);
2651: dbms_sql.bind_variable(outputStmtIdx,
2652: 'currPrecision',
2653: contextData.currPrecision);
2654: if (miToken) then

Line 2651: dbms_sql.bind_variable(outputStmtIdx,

2647: dbms_sql.bind_variable(outputStmtIdx,
2648: 'rule_id',
2649: stepData(stepSeq).rule_id);
2650: dbms_sql.bind_variable(outputStmtIdx, 'seq', stepSeq);
2651: dbms_sql.bind_variable(outputStmtIdx,
2652: 'currPrecision',
2653: contextData.currPrecision);
2654: if (miToken) then
2655: dbms_sql.bind_variable(outputStmtIdx,

Line 2655: dbms_sql.bind_variable(outputStmtIdx,

2651: dbms_sql.bind_variable(outputStmtIdx,
2652: 'currPrecision',
2653: contextData.currPrecision);
2654: if (miToken) then
2655: dbms_sql.bind_variable(outputStmtIdx,
2656: 'min',
2657: 1 - ruleData.toPercent);
2658: end if;
2659: if (ownToken) then

Line 2660: dbms_sql.bind_variable(outputStmtIdx, 'own', ruleData.toPercent);

2656: 'min',
2657: 1 - ruleData.toPercent);
2658: end if;
2659: if (ownToken) then
2660: dbms_sql.bind_variable(outputStmtIdx, 'own', ruleData.toPercent);
2661: end if;
2662: dbmsSqlVal := dbms_sql.execute(outputStmtIdx);
2663: dbms_sql.close_cursor(outputStmtIdx);
2664:

Line 2662: dbmsSqlVal := dbms_sql.execute(outputStmtIdx);

2658: end if;
2659: if (ownToken) then
2660: dbms_sql.bind_variable(outputStmtIdx, 'own', ruleData.toPercent);
2661: end if;
2662: dbmsSqlVal := dbms_sql.execute(outputStmtIdx);
2663: dbms_sql.close_cursor(outputStmtIdx);
2664:
2665: /*
2666: IF (cEntityType= 'C') THEN

Line 2663: dbms_sql.close_cursor(outputStmtIdx);

2659: if (ownToken) then
2660: dbms_sql.bind_variable(outputStmtIdx, 'own', ruleData.toPercent);
2661: end if;
2662: dbmsSqlVal := dbms_sql.execute(outputStmtIdx);
2663: dbms_sql.close_cursor(outputStmtIdx);
2664:
2665: /*
2666: IF (cEntityType= 'C') THEN
2667: EXECUTE IMMEDIATE entriesStmt

Line 2983: -- within the stmt, it cannot support this requirement. DBMS_SQL can do

2979: -- anticipate the various combinations and order of occurance of the bind
2980: -- variables involved in these stmts, since the formula expression may use
2981: -- any, all or no variable(s) in any order the customer desires. Since
2982: -- native dynamic SQL can only bind values based on the relative position
2983: -- within the stmt, it cannot support this requirement. DBMS_SQL can do
2984: -- the bind by variable name and so must be used instead.
2985: --
2986: -- For example...
2987: -- Given that cctr_org, nat acct, IC, product and user1 are GCS active

Line 3035: row_id DBMS_SQL.varchar2_table;

3031: procedure execFormulas(stepSeq IN Number) is
3032:
3033: procedureName varchar2(30);
3034:
3035: row_id DBMS_SQL.varchar2_table;
3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;

Line 3036: sourceAmt DBMS_SQL.number_table;

3032:
3033: procedureName varchar2(30);
3034:
3035: row_id DBMS_SQL.varchar2_table;
3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;

Line 3037: targetAmt DBMS_SQL.number_table;

3033: procedureName varchar2(30);
3034:
3035: row_id DBMS_SQL.varchar2_table;
3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;

Line 3038: t1Amt DBMS_SQL.number_table;

3034:
3035: row_id DBMS_SQL.varchar2_table;
3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;
3042: eeAmt DBMS_SQL.number_table;

Line 3039: t2Amt DBMS_SQL.number_table;

3035: row_id DBMS_SQL.varchar2_table;
3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;
3042: eeAmt DBMS_SQL.number_table;
3043:

Line 3040: peAmt DBMS_SQL.number_table;

3036: sourceAmt DBMS_SQL.number_table;
3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;
3042: eeAmt DBMS_SQL.number_table;
3043:
3044: dc1 integer;

Line 3041: ceAmt DBMS_SQL.number_table;

3037: targetAmt DBMS_SQL.number_table;
3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;
3042: eeAmt DBMS_SQL.number_table;
3043:
3044: dc1 integer;
3045: i number := 0; --a re-usable index

Line 3042: eeAmt DBMS_SQL.number_table;

3038: t1Amt DBMS_SQL.number_table;
3039: t2Amt DBMS_SQL.number_table;
3040: peAmt DBMS_SQL.number_table;
3041: ceAmt DBMS_SQL.number_table;
3042: eeAmt DBMS_SQL.number_table;
3043:
3044: dc1 integer;
3045: i number := 0; --a re-usable index
3046: stmt number := 0; --SQL statement index

Line 3066: dc1 := DBMS_SQL.open_cursor;

3062: procedureName,
3063: 'begin',
3064: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3065:
3066: dc1 := DBMS_SQL.open_cursor;
3067:
3068: --=======================================================
3069: logString(eventLogLevel, procedureName, 'section', '1');
3070: --=======================================================

Line 3195: DBMS_SQL.parse(dc1, sqlStmt, 1);

3191: procedureName,
3192: 'stmt',
3193: 'sqlStmt =
3194: ' || sqlStmt);
3195: DBMS_SQL.parse(dc1, sqlStmt, 1);
3196:
3197: --=======================================================
3198: logString(eventLogLevel, procedureName, 'section', '4');
3199: --=======================================================

Line 3242: DBMS_SQL.bind_variable(dc1, 'coi', ruleData.consideration);

3238: logString(statementLogLevel,
3239: procedureName,
3240: 'bind',
3241: 'truecoi=' || ruleData.consideration);
3242: DBMS_SQL.bind_variable(dc1, 'coi', ruleData.consideration);
3243: else
3244: --Bugfix 6242317: Need to Divide COI by the number of rows for the specific step
3245: if (lRowCount <> 0) then
3246: logString(statementLogLevel,

Line 3250: DBMS_SQL.bind_variable(dc1,

3246: logString(statementLogLevel,
3247: procedureName,
3248: 'bind',
3249: 'truecoi=' || ruleData.consideration / lRowCount);
3250: DBMS_SQL.bind_variable(dc1,
3251: 'coi',
3252: ruleData.consideration / lRowCount);
3253: else
3254: logString(statementLogLevel,

Line 3258: DBMS_SQL.bind_variable(dc1, 'coi', 0);

3254: logString(statementLogLevel,
3255: procedureName,
3256: 'bind',
3257: 'truecoi=0');
3258: DBMS_SQL.bind_variable(dc1, 'coi', 0);
3259: end if;
3260: end if;
3261: elsif varName = 'nav' then
3262: --Bugfix 6511825: Need to Divide NAV by the number of rows for the specific step

Line 3268: DBMS_SQL.bind_variable(dc1, 'nav', ruleData.netAssetValue);

3264: logString(statementLogLevel,
3265: procedureName,
3266: 'bind',
3267: 'truenav=' || ruleData.netAssetValue);
3268: DBMS_SQL.bind_variable(dc1, 'nav', ruleData.netAssetValue);
3269: else
3270: if (lRowCount <> 0) then
3271: logString(statementLogLevel,
3272: procedureName,

Line 3275: DBMS_SQL.bind_variable(dc1,

3271: logString(statementLogLevel,
3272: procedureName,
3273: 'bind',
3274: 'truenav=' || to_char(ruleData.netAssetValue / lRowCount));
3275: DBMS_SQL.bind_variable(dc1,
3276: 'nav',
3277: ruleData.netAssetValue / lRowCount);
3278: else
3279: logString(statementLogLevel, procedureName, 'bind', 'nav=0');

Line 3280: DBMS_SQL.bind_variable(dc1, 'nav', 0);

3276: 'nav',
3277: ruleData.netAssetValue / lRowCount);
3278: else
3279: logString(statementLogLevel, procedureName, 'bind', 'nav=0');
3280: DBMS_SQL.bind_variable(dc1, 'nav', 0);
3281: end if;
3282: end if;
3283: elsif varName = 'now' then
3284: logString(statementLogLevel,

Line 3288: DBMS_SQL.bind_variable(dc1, 'now', ruleData.toPercent);

3284: logString(statementLogLevel,
3285: procedureName,
3286: 'bind',
3287: 'now=' || to_char(ruleData.toPercent));
3288: DBMS_SQL.bind_variable(dc1, 'now', ruleData.toPercent);
3289:
3290: elsif varName = 'was' then
3291: logString(statementLogLevel,
3292: procedureName,

Line 3295: DBMS_SQL.bind_variable(dc1, 'was', ruleData.fromPercent);

3291: logString(statementLogLevel,
3292: procedureName,
3293: 'bind',
3294: 'was=' || to_char(ruleData.fromPercent));
3295: DBMS_SQL.bind_variable(dc1, 'was', ruleData.fromPercent);
3296:
3297: elsif varName = 'own' then
3298: logString(statementLogLevel,
3299: procedureName,

Line 3302: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);

3298: logString(statementLogLevel,
3299: procedureName,
3300: 'bind',
3301: 'own=' || to_char(ruleData.toPercent));
3302: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);
3303:
3304: elsif varName = 'min' then
3305: logString(statementLogLevel,
3306: procedureName,

Line 3309: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);

3305: logString(statementLogLevel,
3306: procedureName,
3307: 'bind',
3308: 'min=' || to_char(1 - ruleData.toPercent));
3309: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);
3310:
3311: else
3312: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3313: FND_MESSAGE.set_token('PROCEDURE',

Line 3345: DBMS_SQL.bind_variable(dc1, 'cpi', contextData.calPeriodId);

3341: logString(statementLogLevel,
3342: procedureName,
3343: 'bind',
3344: 'cpi=' || to_char(contextData.calPeriodId));
3345: DBMS_SQL.bind_variable(dc1, 'cpi', contextData.calPeriodId);
3346:
3347: elsif varName = 'eid' then
3348: logString(statementLogLevel,
3349: procedureName,

Line 3352: DBMS_SQL.bind_variable(dc1, 'eid', contextData.elimsEntity);

3348: logString(statementLogLevel,
3349: procedureName,
3350: 'bind',
3351: 'eid=' || to_char(contextData.elimsEntity));
3352: DBMS_SQL.bind_variable(dc1, 'eid', contextData.elimsEntity);
3353:
3354: elsif varName = 'sei' then
3355: logString(statementLogLevel,
3356: procedureName,

Line 3359: DBMS_SQL.bind_variable(dc1, 'sei', contextData.childEntity);

3355: logString(statementLogLevel,
3356: procedureName,
3357: 'bind',
3358: 'sei=' || to_char(contextData.childEntity));
3359: DBMS_SQL.bind_variable(dc1, 'sei', contextData.childEntity);
3360:
3361: elsif varName = 'pei' then
3362: logString(statementLogLevel,
3363: procedureName,

Line 3366: DBMS_SQL.bind_variable(dc1, 'pei', contextData.parentEntity);

3362: logString(statementLogLevel,
3363: procedureName,
3364: 'bind',
3365: 'pei=' || to_char(contextData.parentEntity));
3366: DBMS_SQL.bind_variable(dc1, 'pei', contextData.parentEntity);
3367:
3368: elsif varName = 'dci' then
3369: logString(statementLogLevel,
3370: procedureName,

Line 3373: DBMS_SQL.bind_variable(dc1, 'dci', contextData.datasetCode);

3369: logString(statementLogLevel,
3370: procedureName,
3371: 'bind',
3372: 'dci=' || to_char(contextData.datasetCode));
3373: DBMS_SQL.bind_variable(dc1, 'dci', contextData.datasetCode);
3374:
3375: elsif varName = 'ccy' then
3376: logString(statementLogLevel,
3377: procedureName,

Line 3380: DBMS_SQL.bind_variable(dc1, 'ccy', contextData.currencyCode);

3376: logString(statementLogLevel,
3377: procedureName,
3378: 'bind',
3379: 'ccy=' || contextData.currencyCode);
3380: DBMS_SQL.bind_variable(dc1, 'ccy', contextData.currencyCode);
3381:
3382: elsif varName = 'xns' then
3383: logString(statementLogLevel,
3384: procedureName,

Line 3387: DBMS_SQL.bind_variable(dc1, 'xns', contextData.eventKey);

3383: logString(statementLogLevel,
3384: procedureName,
3385: 'bind',
3386: 'xns=' || to_char(contextData.eventKey));
3387: DBMS_SQL.bind_variable(dc1, 'xns', contextData.eventKey);
3388:
3389: elsif varName = 'rid' then
3390: logString(statementLogLevel,
3391: procedureName,

Line 3394: DBMS_SQL.bind_variable(dc1, 'rid', stepData(stepSeq).rule_id);

3390: logString(statementLogLevel,
3391: procedureName,
3392: 'bind',
3393: 'rid=' || to_char(stepData(stepSeq).rule_id));
3394: DBMS_SQL.bind_variable(dc1, 'rid', stepData(stepSeq).rule_id);
3395:
3396: elsif varName = 'seq' then
3397: logString(statementLogLevel,
3398: procedureName,

Line 3401: DBMS_SQL.bind_variable(dc1, 'seq', stepSeq);

3397: logString(statementLogLevel,
3398: procedureName,
3399: 'bind',
3400: 'seq=' || to_char(stepSeq));
3401: DBMS_SQL.bind_variable(dc1, 'seq', stepSeq);
3402:
3403: else
3404: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3405: FND_MESSAGE.set_token('PROCEDURE',

Line 3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);

3417: logString(eventLogLevel, procedureName, 'section', '6');
3418: --=======================================================
3419:
3420: --Define columns
3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);
3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);

Line 3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);

3418: --=======================================================
3419:
3420: --Define columns
3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);
3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);

Line 3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);

3419:
3420: --Define columns
3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);
3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);
3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);

Line 3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);

3420: --Define columns
3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);
3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);
3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);
3428:

Line 3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);

3421: DBMS_SQL.define_array(dc1, 1, row_id, fetchSize, 1);
3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);
3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);
3428:
3429: --=======================================================

Line 3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);

3422: DBMS_SQL.define_array(dc1, 2, targetAmt, fetchSize, 1);
3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);
3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);
3428:
3429: --=======================================================
3430: logString(eventLogLevel, procedureName, 'section', '7');

Line 3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);

3423: DBMS_SQL.define_array(dc1, 3, t1Amt, fetchSize, 1);
3424: DBMS_SQL.define_array(dc1, 4, t2Amt, fetchSize, 1);
3425: DBMS_SQL.define_array(dc1, 5, peAmt, fetchSize, 1);
3426: DBMS_SQL.define_array(dc1, 6, ceAmt, fetchSize, 1);
3427: DBMS_SQL.define_array(dc1, 7, eeAmt, fetchSize, 1);
3428:
3429: --=======================================================
3430: logString(eventLogLevel, procedureName, 'section', '7');
3431: --=======================================================

Line 3434: i := DBMS_SQL.execute(dc1);

3430: logString(eventLogLevel, procedureName, 'section', '7');
3431: --=======================================================
3432:
3433: --Execute the dynamic cursor
3434: i := DBMS_SQL.execute(dc1);
3435:
3436: --=======================================================
3437: logString(eventLogLevel, procedureName, 'section', '8');
3438: --=======================================================

Line 3444: i := DBMS_SQL.fetch_rows(dc1);

3440: --Fetch through the cursor (see DEFINE_ARRAY() calls above)
3441: i := fetchSize;
3442:
3443: While i = fetchSize Loop
3444: i := DBMS_SQL.fetch_rows(dc1);
3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);

Line 3445: DBMS_SQL.column_value(dc1, 1, row_id);

3441: i := fetchSize;
3442:
3443: While i = fetchSize Loop
3444: i := DBMS_SQL.fetch_rows(dc1);
3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);

Line 3446: DBMS_SQL.column_value(dc1, 2, targetAmt);

3442:
3443: While i = fetchSize Loop
3444: i := DBMS_SQL.fetch_rows(dc1);
3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);

Line 3447: DBMS_SQL.column_value(dc1, 3, t1Amt);

3443: While i = fetchSize Loop
3444: i := DBMS_SQL.fetch_rows(dc1);
3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);

Line 3448: DBMS_SQL.column_value(dc1, 4, t2Amt);

3444: i := DBMS_SQL.fetch_rows(dc1);
3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);
3452: End Loop; --DBMS_SQL.fetch_rows loop

Line 3449: DBMS_SQL.column_value(dc1, 5, peAmt);

3445: DBMS_SQL.column_value(dc1, 1, row_id);
3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);
3452: End Loop; --DBMS_SQL.fetch_rows loop
3453:

Line 3450: DBMS_SQL.column_value(dc1, 6, ceAmt);

3446: DBMS_SQL.column_value(dc1, 2, targetAmt);
3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);
3452: End Loop; --DBMS_SQL.fetch_rows loop
3453:
3454: logString(statementLogLevel,

Line 3451: DBMS_SQL.column_value(dc1, 7, eeAmt);

3447: DBMS_SQL.column_value(dc1, 3, t1Amt);
3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);
3452: End Loop; --DBMS_SQL.fetch_rows loop
3453:
3454: logString(statementLogLevel,
3455: procedureName,

Line 3452: End Loop; --DBMS_SQL.fetch_rows loop

3448: DBMS_SQL.column_value(dc1, 4, t2Amt);
3449: DBMS_SQL.column_value(dc1, 5, peAmt);
3450: DBMS_SQL.column_value(dc1, 6, ceAmt);
3451: DBMS_SQL.column_value(dc1, 7, eeAmt);
3452: End Loop; --DBMS_SQL.fetch_rows loop
3453:
3454: logString(statementLogLevel,
3455: procedureName,
3456: 'stmt',

Line 3483: DBMS_SQL.close_cursor(dc1);

3479: 'stmt',
3480: to_char(SQL%ROWCOUNT) || ' row(s) updated');
3481: end if;
3482:
3483: DBMS_SQL.close_cursor(dc1);
3484:
3485: -- Done
3486: logString(procedureLogLevel,
3487: procedureName,

Line 3494: if DBMS_SQL.is_open(dc1) then

3490:
3491: exception
3492: when others then
3493: -- make sure we close the cursor and then RAISE
3494: if DBMS_SQL.is_open(dc1) then
3495: DBMS_SQL.close_cursor(dc1);
3496: end if;
3497: RAISE;
3498:

Line 3495: DBMS_SQL.close_cursor(dc1);

3491: exception
3492: when others then
3493: -- make sure we close the cursor and then RAISE
3494: if DBMS_SQL.is_open(dc1) then
3495: DBMS_SQL.close_cursor(dc1);
3496: end if;
3497: RAISE;
3498:
3499: end execFormulas;