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.IBY_FACTOR_PKG dependencies on FND_GLOBAL

Line 62: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

58: payeeid, object_version_number,
59: last_update_date, last_updated_by, creation_date, created_by)
60: values ( l_lowerLimit, l_upperLimit, l_score, l_seq,
61: i_payeeid,1,
62: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
63:
64: /*
65: -- if no rows were created then raise the exception.
66: if ( SQL%ROWCOUNT = 0 ) then

Line 106: --security_group_id = fnd_global.lookup_security_group

102: lookup_code = 'PMTAMOUNT' and
103: lookup_type = 'IBY_RISK_FACTOR_NAME' and
104: language = userenv('LANG');
105: --and
106: --security_group_id = fnd_global.lookup_security_group
107: --(lookup_type,view_application_id);
108:
109: cursor c_load_ranges(ci_payeeid VARCHAR2) is
110: select lower_limit, upper_limit, seq, score

Line 232: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

228: payeeid , object_version_number,
229: last_update_date, last_updated_by, creation_date, created_by)
230: values ( l_lowerLimit, l_upperLimit, l_score, l_seq,
231: i_payeeid,1,
232: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
233:
234: -- if inserted number of rows is zero then raise an exception.
235: /*
236: if ( SQL%ROWCOUNT = 0 ) then

Line 278: --security_group_id = fnd_global.lookup_security_group

274: lookup_code = 'TIMEOFPURCHASE' and
275: lookup_type = 'IBY_RISK_FACTOR_NAME' and
276: language = userenv('LANG');
277: --and
278: --security_group_id = fnd_global.lookup_security_group
279: --(lookup_type,view_application_id);
280:
281:
282:

Line 378: last_updated_by = fnd_global.user_id

374: set duration = i_duration,
375: duration_type = i_durationType,
376: amount = i_amount,
377: last_update_date = sysdate,
378: last_updated_by = fnd_global.user_id
379: where (( payeeid is null and i_payeeid is null ) or
380: ( payeeid = i_payeeid));
381:
382: -- if there are no rows present insert rows into database.

Line 393: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

389: payeeid, object_version_number,
390: last_update_date, last_updated_by, creation_date, created_by)
391: values (i_duration, i_durationType, i_amount,
392: i_payeeid,1,
393: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
394:
395: /*
396: -- if information could not be saved then raise
397: -- application error.

Line 437: --security_group_id = fnd_global.lookup_security_group

433: lookup_code = 'TRXNAMOUNT' and
434: lookup_type = 'IBY_RISK_FACTOR_NAME' and
435: language = userenv('LANG');
436: --and
437: --security_group_id = fnd_global.lookup_security_group
438: --(lookup_type,view_application_id);
439:
440:
441: cursor c_trxn_amount_limit(ci_payeeid varchar2) is

Line 544: last_updated_by = fnd_global.user_id

540: update iby_irf_pmt_history
541: set duration = i_duration,
542: duration_type = i_durationType,
543: last_update_date = sysdate,
544: last_updated_by = fnd_global.user_id
545: where (( payeeid is null and i_payeeid is null) or
546: ( payeeid = i_payeeid));
547:
548: if ( SQL%ROWCOUNT = 0 ) then

Line 558: 1, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

554: insert into iby_irf_pmt_history (id, duration, duration_type,
555: payeeid, object_version_number,
556: last_update_date, last_updated_by, creation_date, created_by)
557: values ( l_pmt_hist_id, i_duration, i_durationType, i_payeeid,
558: 1, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
559:
560: else
561: open c_pmtHistId(i_payeeId);
562: fetch c_pmtHistId into l_pmt_hist_id;

Line 598: sysdate, fnd_global.user_id,

594:
595: values ( l_pmt_hist_id, l_lowerlimit, l_upperlimit,
596: l_score, l_seq,
597: 1,
598: sysdate, fnd_global.user_id,
599: sysdate, fnd_global.user_id);
600:
601: /*
602: -- if no data was inserted then raise the exceotion.

Line 599: sysdate, fnd_global.user_id);

595: values ( l_pmt_hist_id, l_lowerlimit, l_upperlimit,
596: l_score, l_seq,
597: 1,
598: sysdate, fnd_global.user_id,
599: sysdate, fnd_global.user_id);
600:
601: /*
602: -- if no data was inserted then raise the exceotion.
603: if ( SQL%ROWCOUNT = 0 ) then

Line 649: --security_group_id = fnd_global.lookup_security_group

645: lookup_code = 'PMTHISTORY' and
646: lookup_type = 'IBY_RISK_FACTOR_NAME' and
647: language = userenv('LANG');
648: --and
649: --security_group_id = fnd_global.lookup_security_group
650: --(lookup_type,view_application_id);
651:
652:
653: cursor c_load_pmt_history(ci_payeeid varchar2) is

Line 775: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

771: value, object_version_number,
772: last_update_date, last_updated_by, creation_date, created_by)
773: values ( i_payeeid, 'AVS_CODE_TYPE', l_code,
774: l_score,1,
775: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
776:
777: /*
778: -- if no of rows inserted is zero then raise an
779: -- exception.

Line 818: --security_group_id = fnd_global.lookup_security_group

814: lookup_code = 'AVSCODES' and
815: lookup_type = 'IBY_RISK_FACTOR_NAME' and
816: language = userenv('LANG');
817: --and
818: --security_group_id = fnd_global.lookup_security_group
819: --(lookup_type,view_application_id);
820:
821:
822: cursor c_avs_codes(ci_payeeid varchar2) is

Line 929: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,1);

925:
926: insert into iby_mappings ( payeeid, mapping_type, mapping_code, value,
927: last_update_date, last_updated_by, creation_date, created_by,object_version_number)
928: values ( i_payeeid, 'RISK_CODE_TYPE', l_code, l_score,
929: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,1);
930:
931: /*
932: if ( SQL%ROWCOUNT = 0 ) then
933: -- raise application error

Line 968: --security_group_id = fnd_global.lookup_security_group

964: lookup_code = 'RISKCODES' and
965: lookup_type = 'IBY_RISK_FACTOR_NAME' and
966: language = userenv('LANG');
967: --and
968: --security_group_id = fnd_global.lookup_security_group
969: --(lookup_type,view_application_id);
970:
971:
972: cursor c_risk_codes(ci_payeeid varchar2) is

Line 984: --security_group_id = fnd_global.lookup_security_group

980: where lookup_type = 'RISK_CODE' and
981: enabled_flag = 'Y' and
982: language = userenv('LANG') and
983:
984: --security_group_id = fnd_global.lookup_security_group
985: --(lookup_type,view_application_id) and
986:
987: lookup_code not in ( select mapping_code
988: from iby_mappings

Line 1002: --security_group_id = fnd_global.lookup_security_group

998: lookup_type = 'RISK_CODE' and
999: enabled_flag = 'Y' and
1000: language = userenv('LANG');
1001: --and
1002: --security_group_id = fnd_global.lookup_security_group
1003: --(lookup_type,view_application_id);
1004:
1005:
1006:

Line 1016: --b.security_group_id = fnd_global.lookup_security_group

1012: b.enabled_flag = 'N' and
1013: b.lookup_code = a.mapping_code and
1014: b.language = userenv('LANG');
1015: --and
1016: --b.security_group_id = fnd_global.lookup_security_group
1017: --(b.lookup_type,b.view_application_id);
1018:
1019: --del_code c_del_risk_codes%ROWTYPE;
1020:

Line 1137: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,1);

1133: i := i+1;
1134: insert into iby_mappings ( payeeid, mapping_type, mapping_code, value,
1135: last_update_date, last_updated_by, creation_date, created_by,object_version_number)
1136: values ( i_payeeid, 'CREDIT_CODE_TYPE', l_code, l_score,
1137: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,1);
1138:
1139: /*
1140: if ( SQL%ROWCOUNT = 0 ) then
1141: -- raise application error

Line 1176: --security_group_id = fnd_global.lookup_security_group

1172: lookup_code = 'CREDITRATINGCODES' and
1173: lookup_type = 'IBY_RISK_FACTOR_NAME' and
1174: language = userenv('LANG');
1175: --and
1176: --security_group_id = fnd_global.lookup_security_group
1177: --(lookup_type,view_application_id);
1178:
1179:
1180: cursor c_creditrating_codes(ci_payeeid varchar2) is

Line 1192: --security_group_id = fnd_global.lookup_security_group

1188: where lookup_type = 'CREDIT_RATING' and
1189: enabled_flag = 'Y' and
1190: language = userenv('LANG') and
1191:
1192: --security_group_id = fnd_global.lookup_security_group
1193: --(lookup_type,view_application_id) and
1194:
1195: lookup_code not in ( select mapping_code
1196: from iby_mappings

Line 1210: --security_group_id = fnd_global.lookup_security_group

1206: lookup_type = 'CREDIT_RATING' and
1207: enabled_flag = 'Y' and
1208: language = userenv('LANG');
1209: --and
1210: --security_group_id = fnd_global.lookup_security_group
1211: --(lookup_type,view_application_id);
1212:
1213: cursor c_del_creditrating_codes is
1214: select lookup_code

Line 1222: --b.security_group_id = fnd_global.lookup_security_group

1218: b.enabled_flag = 'N' and
1219: b.lookup_code = a.mapping_code and
1220: b.language = userenv('LANG');
1221: --and
1222: --b.security_group_id = fnd_global.lookup_security_group
1223: --(b.lookup_type,b.view_application_id);
1224:
1225:
1226: cursor c_creditrating_codes_count(ci_payeeid varchar2) is

Line 1321: last_updated_by = fnd_global.user_id

1317: set duration = i_duration,
1318: duration_type = i_durationType,
1319: frequency = i_frequency,
1320: last_update_date = sysdate,
1321: last_updated_by = fnd_global.user_id
1322: where ( ( payeeid is null and i_payeeid is null ) or
1323: ( payeeid = i_payeeid ));
1324:
1325: -- if no data configured.

Line 1332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

1328: insert into iby_irf_pmt_frequency ( duration, duration_type,
1329: frequency, payeeid, object_version_number,
1330: last_update_date, last_updated_by, creation_date, created_by)
1331: values ( i_duration, i_durationType, i_frequency, i_payeeid,1,
1332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
1333: /*
1334: -- if it could not insert the rows.
1335: if ( SQL%ROWCOUNT = 0 ) then
1336: -- raise application error

Line 1375: --security_group_id = fnd_global.lookup_security_group

1371: lookup_code = 'FREQOFPURCHASE' and
1372: lookup_type = 'IBY_RISK_FACTOR_NAME' and
1373: language = userenv('LANG');
1374: --and
1375: --security_group_id = fnd_global.lookup_security_group
1376: --(lookup_type,view_application_id);
1377:
1378:
1379: cursor c_pmt_freq(ci_payeeid varchar2) is

Line 1462: last_updated_by = fnd_global.user_id

1458: -- update the risk scores based on the payeeid.
1459: update iby_mappings
1460: set value = i_lowVal,
1461: last_update_date = sysdate,
1462: last_updated_by = fnd_global.user_id
1463: where mapping_code = 'L'
1464: and mapping_type = 'IBY_RISK_SCORE_TYPE'
1465: and (( payeeid is null and i_payeeid is null ) or
1466: (payeeid = i_payeeid) );

Line 1474: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1470: if ( SQL%ROWCOUNT = 0 ) then
1471: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1472: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1473: values( 0, 'S', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1474: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1475:
1476: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1477: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1478: values( 0, 'NR', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1479: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1475:
1476: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1477: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1478: values( 0, 'NR', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1479: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1480:
1481: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1482: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1483: values( i_lowVal, 'L', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1484: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1480:
1481: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1482: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1483: values( i_lowVal, 'L', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1484: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1485:
1486: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1487: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1488: values( i_lowMedVal, 'LM', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1489: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1485:
1486: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1487: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1488: values( i_lowMedVal, 'LM', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1489: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1490:
1491: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1492: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1493: values( i_medVal, 'M', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1494: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1490:
1491: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1492: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1493: values( i_medVal, 'M', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1494: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1495:
1496: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1497: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1498: values( i_medHighVal, 'MH', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1499: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1495:
1496: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1497: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1498: values( i_medHighVal, 'MH', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1499: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1500:
1501: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1502: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1503: values( i_highVal, 'H', 'IBY_RISK_SCORE_TYPE', i_payeeid,

Line 1504: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);

1500:
1501: insert into iby_mappings( value, mapping_code, mapping_type, payeeid,
1502: last_update_date, last_updated_by, creation_date, created_by, object_version_number)
1503: values( i_highVal, 'H', 'IBY_RISK_SCORE_TYPE', i_payeeid,
1504: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, 1);
1505: else
1506:
1507: update iby_mappings
1508: set value = i_lowMedVal,

Line 1510: last_updated_by = fnd_global.user_id

1506:
1507: update iby_mappings
1508: set value = i_lowMedVal,
1509: last_update_date = sysdate,
1510: last_updated_by = fnd_global.user_id
1511: where mapping_code = 'LM'
1512: and mapping_type = 'IBY_RISK_SCORE_TYPE'
1513: and (( payeeid is null and i_payeeid is null ) or
1514: (payeeid = i_payeeid) );

Line 1519: last_updated_by = fnd_global.user_id

1515:
1516: update iby_mappings
1517: set value = i_medVal,
1518: last_update_date = sysdate,
1519: last_updated_by = fnd_global.user_id
1520: where mapping_code = 'M'
1521: and mapping_type = 'IBY_RISK_SCORE_TYPE'
1522: and (( payeeid is null and i_payeeid is null ) or
1523: (payeeid = i_payeeid) );

Line 1528: last_updated_by = fnd_global.user_id

1524:
1525: update iby_mappings
1526: set value = i_medHighVal,
1527: last_update_date = sysdate,
1528: last_updated_by = fnd_global.user_id
1529: where mapping_code = 'MH'
1530: and mapping_type = 'IBY_RISK_SCORE_TYPE'
1531: and (( payeeid is null and i_payeeid is null ) or
1532: (payeeid = i_payeeid) );

Line 1537: last_updated_by = fnd_global.user_id

1533:
1534: update iby_mappings
1535: set value = i_highVal,
1536: last_update_date = sysdate,
1537: last_updated_by = fnd_global.user_id
1538: where mapping_code = 'H'
1539: and mapping_type = 'IBY_RISK_SCORE_TYPE'
1540: and (( payeeid is null and i_payeeid is null ) or
1541: (payeeid = i_payeeid) );