DBA Data[Home] [Help]

APPS.ZX_RATES_PKG dependencies on FND_GLOBAL

Line 34: last_updated_by = FND_GLOBAL.user_id,

30: UPDATE FND_LOOKUP_VALUES
31: SET description=P_DESCRIPTION,
32: meaning = Nvl(P_MEANING, P_TAX_RATE_CODE),
33: last_update_date = SYSDATE,
34: last_updated_by = FND_GLOBAL.user_id,
35: last_update_login = FND_GLOBAL.login_id
36:
37: WHERE
38: LOOKUP_TYPE = P_LOOKUP_TYPE and

Line 35: last_update_login = FND_GLOBAL.login_id

31: SET description=P_DESCRIPTION,
32: meaning = Nvl(P_MEANING, P_TAX_RATE_CODE),
33: last_update_date = SYSDATE,
34: last_updated_by = FND_GLOBAL.user_id,
35: last_update_login = FND_GLOBAL.login_id
36:
37: WHERE
38: LOOKUP_TYPE = P_LOOKUP_TYPE and
39: LOOKUP_CODE = NVL(TAG,P_TAX_RATE_CODE)and

Line 1018: fnd_global.user_id,

1014: 'US',
1015: '0',
1016: '0',
1017: SYSDATE,
1018: fnd_global.user_id,
1019: SYSDATE,
1020: fnd_global.user_id,
1021: FND_GLOBAL.CONC_LOGIN_ID);
1022:

Line 1020: fnd_global.user_id,

1016: '0',
1017: SYSDATE,
1018: fnd_global.user_id,
1019: SYSDATE,
1020: fnd_global.user_id,
1021: FND_GLOBAL.CONC_LOGIN_ID);
1022:
1023:
1024: end INSERT_LOOKUP_VALUES;

Line 1021: FND_GLOBAL.CONC_LOGIN_ID);

1017: SYSDATE,
1018: fnd_global.user_id,
1019: SYSDATE,
1020: fnd_global.user_id,
1021: FND_GLOBAL.CONC_LOGIN_ID);
1022:
1023:
1024: end INSERT_LOOKUP_VALUES;
1025:

Line 1105: LAST_UPDATED_BY = fnd_global.user_id, --last_updated_by

1101: UPDATE ZX_ID_TCC_MAPPING_ALL
1102: SET
1103: EFFECTIVE_TO = L_EFFECTIVE_TO, --effective_to
1104: ACTIVE_FLAG = X_Active_Flag, -- Active_flag
1105: LAST_UPDATED_BY = fnd_global.user_id, --last_updated_by
1106: LAST_UPDATE_DATE = SYSDATE, --last_update_date
1107: LAST_UPDATE_LOGIN = fnd_global.user_id --last_update_login
1108: WHERE TAX_CLASSIFICATION_CODE = X_TAX_RATE_CODE
1109: AND ORG_ID = X_ORG_ID

Line 1107: LAST_UPDATE_LOGIN = fnd_global.user_id --last_update_login

1103: EFFECTIVE_TO = L_EFFECTIVE_TO, --effective_to
1104: ACTIVE_FLAG = X_Active_Flag, -- Active_flag
1105: LAST_UPDATED_BY = fnd_global.user_id, --last_updated_by
1106: LAST_UPDATE_DATE = SYSDATE, --last_update_date
1107: LAST_UPDATE_LOGIN = fnd_global.user_id --last_update_login
1108: WHERE TAX_CLASSIFICATION_CODE = X_TAX_RATE_CODE
1109: AND ORG_ID = X_ORG_ID
1110: AND ((TAX_RATE_CODE_ID = X_TAX_RATE_ID) OR
1111: (X_TAX_RATE_ID < 0));

Line 1149: fnd_global.user_id , --created_by

1145: X_TAX_TYPE , --tax_type
1146: L_EFFECTIVE_FROM , --effective_from
1147: L_EFFECTIVE_TO , --effective_to
1148: X_SOURCE , --source
1149: fnd_global.user_id , --created_by
1150: SYSDATE , --creation_date
1151: fnd_global.user_id , --last_updated_by
1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login

Line 1151: fnd_global.user_id , --last_updated_by

1147: L_EFFECTIVE_TO , --effective_to
1148: X_SOURCE , --source
1149: fnd_global.user_id , --created_by
1150: SYSDATE , --creation_date
1151: fnd_global.user_id , --last_updated_by
1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id

Line 1153: fnd_global.user_id , --last_update_login

1149: fnd_global.user_id , --created_by
1150: SYSDATE , --creation_date
1151: fnd_global.user_id , --last_updated_by
1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id
1156: fnd_global.conc_program_id , --program_id
1157: fnd_global.conc_login_id , --program_login_id

Line 1154: fnd_global.conc_request_id , --request_id

1150: SYSDATE , --creation_date
1151: fnd_global.user_id , --last_updated_by
1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id
1156: fnd_global.conc_program_id , --program_id
1157: fnd_global.conc_login_id , --program_login_id
1158: X_LEDGER_ID , --ledger_id

Line 1155: fnd_global.prog_appl_id , --program_application_id

1151: fnd_global.user_id , --last_updated_by
1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id
1156: fnd_global.conc_program_id , --program_id
1157: fnd_global.conc_login_id , --program_login_id
1158: X_LEDGER_ID , --ledger_id
1159: X_Active_Flag -- Active_flag )

Line 1156: fnd_global.conc_program_id , --program_id

1152: SYSDATE , --last_update_date
1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id
1156: fnd_global.conc_program_id , --program_id
1157: fnd_global.conc_login_id , --program_login_id
1158: X_LEDGER_ID , --ledger_id
1159: X_Active_Flag -- Active_flag )
1160: FROM

Line 1157: fnd_global.conc_login_id , --program_login_id

1153: fnd_global.user_id , --last_update_login
1154: fnd_global.conc_request_id , --request_id
1155: fnd_global.prog_appl_id , --program_application_id
1156: fnd_global.conc_program_id , --program_id
1157: fnd_global.conc_login_id , --program_login_id
1158: X_LEDGER_ID , --ledger_id
1159: X_Active_Flag -- Active_flag )
1160: FROM
1161: dual