DBA Data[Home] [Help]

APPS.IBY_ROUTINGINFO_PKG dependencies on FND_GLOBAL

Line 54: i_rules.priority, sysdate, fnd_global.user_id, sysdate,

50: configured, priority, last_update_date, last_updated_by, creation_date,
51: created_by, last_update_login, hitcounter, object_version_number)
52: VALUES ( i_rules.payeeId, i_rules.merchantAccount, i_rules.bepId, l_ruleId,
53: i_rules.ruleName, i_rules.bepInstrType, i_rules.activeStatus,
54: i_rules.priority, sysdate, fnd_global.user_id, sysdate,
55: fnd_global.user_id, fnd_global.login_id, i_rules.hitcounter, 1);
56:
57: FOR v_count in 1..i_conditions.COUNT LOOP
58: INSERT INTO iby_pmtmthd_conditions

Line 55: fnd_global.user_id, fnd_global.login_id, i_rules.hitcounter, 1);

51: created_by, last_update_login, hitcounter, object_version_number)
52: VALUES ( i_rules.payeeId, i_rules.merchantAccount, i_rules.bepId, l_ruleId,
53: i_rules.ruleName, i_rules.bepInstrType, i_rules.activeStatus,
54: i_rules.priority, sysdate, fnd_global.user_id, sysdate,
55: fnd_global.user_id, fnd_global.login_id, i_rules.hitcounter, 1);
56:
57: FOR v_count in 1..i_conditions.COUNT LOOP
58: INSERT INTO iby_pmtmthd_conditions
59: (paymentmethodid, parameter_code, operation_code, value,

Line 67: i_conditions(v_count).condition_name, sysdate, fnd_global.user_id,

63: VALUES ( l_ruleId, i_conditions(v_count).parameter,
64: i_conditions(v_count).operation, i_conditions(v_count).value,
65: i_conditions(v_count).is_value_string,
66: i_conditions(v_count).entry_seq,
67: i_conditions(v_count).condition_name, sysdate, fnd_global.user_id,
68: sysdate, fnd_global.user_id, fnd_global.login_id, 1);
69: END LOOP;
70: ELSE
71: raise_application_error(-20000, 'IBY_204559#', FALSE);

Line 68: sysdate, fnd_global.user_id, fnd_global.login_id, 1);

64: i_conditions(v_count).operation, i_conditions(v_count).value,
65: i_conditions(v_count).is_value_string,
66: i_conditions(v_count).entry_seq,
67: i_conditions(v_count).condition_name, sysdate, fnd_global.user_id,
68: sysdate, fnd_global.user_id, fnd_global.login_id, 1);
69: END LOOP;
70: ELSE
71: raise_application_error(-20000, 'IBY_204559#', FALSE);
72: --raise_application_error(-20520,

Line 128: last_update_date = sysdate, last_updated_by = fnd_global.user_id,

124: UPDATE iby_routinginfo
125: SET payeeid = i_rules.payeeId, bepkey = i_rules.merchantAccount,
126: bepid = i_rules.bepid, configured = i_rules.activeStatus,
127: instr_type = i_rules.bepInstrType, priority = i_rules.priority,
128: last_update_date = sysdate, last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id,
130: hitcounter = i_rules.hitcounter,
131: object_version_number = object_version_number+1
132: WHERE CURRENT OF c_routingInfo;

Line 129: last_update_login = fnd_global.login_id,

125: SET payeeid = i_rules.payeeId, bepkey = i_rules.merchantAccount,
126: bepid = i_rules.bepid, configured = i_rules.activeStatus,
127: instr_type = i_rules.bepInstrType, priority = i_rules.priority,
128: last_update_date = sysdate, last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id,
130: hitcounter = i_rules.hitcounter,
131: object_version_number = object_version_number+1
132: WHERE CURRENT OF c_routingInfo;
133: END LOOP;