992: NVL(X_Enabled_Flag(i),'N'),
993: X_APPLICATION_ID(i),
994: X_CONTENT_OWNER_ID(i),
995: X_DET_FACTOR_TEMPL_CODE(i),
996: fnd_global.user_id ,
997: sysdate ,
998: fnd_global.user_id ,
999: sysdate ,
1000: fnd_global.conc_login_id ,
994: X_CONTENT_OWNER_ID(i),
995: X_DET_FACTOR_TEMPL_CODE(i),
996: fnd_global.user_id ,
997: sysdate ,
998: fnd_global.user_id ,
999: sysdate ,
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
996: fnd_global.user_id ,
997: sysdate ,
998: fnd_global.user_id ,
999: sysdate ,
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
1003: fnd_global.conc_program_id ,
1004: fnd_global.conc_login_id
997: sysdate ,
998: fnd_global.user_id ,
999: sysdate ,
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
1003: fnd_global.conc_program_id ,
1004: fnd_global.conc_login_id
1005: );
998: fnd_global.user_id ,
999: sysdate ,
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
1003: fnd_global.conc_program_id ,
1004: fnd_global.conc_login_id
1005: );
1006:
999: sysdate ,
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
1003: fnd_global.conc_program_id ,
1004: fnd_global.conc_login_id
1005: );
1006:
1007: forall i in x_tax_rule_id.first..x_tax_rule_id.last
1000: fnd_global.conc_login_id ,
1001: fnd_global.conc_request_id ,
1002: fnd_global.prog_appl_id ,
1003: fnd_global.conc_program_id ,
1004: fnd_global.conc_login_id
1005: );
1006:
1007: forall i in x_tax_rule_id.first..x_tax_rule_id.last
1008: INSERT INTO ZX_RULES_TL (TAX_RULE_ID,
1018: select
1019: X_TAX_RULE_ID(i),
1020: X_TAX_RULE_NAME(i),
1021: X_TAX_RULE_DESC(i),
1022: fnd_global.user_id ,
1023: sysdate ,
1024: fnd_global.user_id ,
1025: sysdate ,
1026: fnd_global.conc_login_id ,
1020: X_TAX_RULE_NAME(i),
1021: X_TAX_RULE_DESC(i),
1022: fnd_global.user_id ,
1023: sysdate ,
1024: fnd_global.user_id ,
1025: sysdate ,
1026: fnd_global.conc_login_id ,
1027: L.LANGUAGE_CODE,
1028: userenv('LANG')
1022: fnd_global.user_id ,
1023: sysdate ,
1024: fnd_global.user_id ,
1025: sysdate ,
1026: fnd_global.conc_login_id ,
1027: L.LANGUAGE_CODE,
1028: userenv('LANG')
1029: from FND_LANGUAGES L
1030: where L.INSTALLED_FLAG in ('I', 'B')