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.PAY_ORG_PAYMENT_METHODS_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F_TL

Line 218: insert into PAY_ORG_PAYMENT_METHODS_F_TL (

214: --
215: -- **************************************************************************
216: -- insert into MLS table (TL)
217: --
218: insert into PAY_ORG_PAYMENT_METHODS_F_TL (
219: ORG_PAYMENT_METHOD_ID,
220: ORG_PAYMENT_METHOD_NAME,
221: LAST_UPDATE_DATE,
222: CREATION_DATE,

Line 236: from PAY_ORG_PAYMENT_METHODS_F_TL T

232: from FND_LANGUAGES L
233: where L.INSTALLED_FLAG in ('I', 'B')
234: and not exists
235: (select NULL
236: from PAY_ORG_PAYMENT_METHODS_F_TL T
237: where T.ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
238: and T.LANGUAGE = L.LANGUAGE_CODE);
239:
240: --

Line 323: FROM pay_org_payment_methods_f_tl ptt,

319: cursor c_translation(p_language IN VARCHAR2,
320: p_org_payment_method_name IN VARCHAR2,
321: p_org_payment_method_id IN NUMBER) IS
322: SELECT 1
323: FROM pay_org_payment_methods_f_tl ptt,
324: pay_org_payment_methods_f ptm
325: WHERE upper(ptt.org_payment_method_name)=upper(p_org_payment_method_name)
326: AND ptt.org_payment_method_id = ptm.org_payment_method_id
327: AND ptt.language = p_language

Line 385: delete from PAY_ORG_PAYMENT_METHODS_F_TL

381: -- ********************************************************************************
382: --
383: -- delete from MLS table (TL)
384: --
385: delete from PAY_ORG_PAYMENT_METHODS_F_TL
386: where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
387: and not exists
388: (select null
389: from pay_org_payment_methods_f o

Line 913: update PAY_ORG_PAYMENT_METHODS_F_TL set

909: -- ****************************************************************************************
910: --
911: -- update MLS table (TL)
912: --
913: update PAY_ORG_PAYMENT_METHODS_F_TL set
914: ORG_PAYMENT_METHOD_NAME = P_ORG_PAYMENT_METHOD_NAME,
915: LAST_UPDATE_DATE = sysdate,
916: SOURCE_LANG = userenv('LANG')
917: where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID

Line 975: update PAY_ORG_PAYMENT_METHODS_F_TL set

971: else
972: -- do a non DT update
973: -- update MLS table (TL)
974: --
975: update PAY_ORG_PAYMENT_METHODS_F_TL set
976: ORG_PAYMENT_METHOD_NAME = P_ORG_PAYMENT_METHOD_NAME,
977: LAST_UPDATE_DATE = sysdate,
978: SOURCE_LANG = userenv('LANG')
979: where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID

Line 999: delete from PAY_ORG_PAYMENT_METHODS_F_TL T

995: ------------------------------------------------------------------------------------------
996: procedure ADD_LANGUAGE
997: is
998: begin
999: delete from PAY_ORG_PAYMENT_METHODS_F_TL T
1000: where not exists
1001: (select NULL
1002: from PAY_ORG_PAYMENT_METHODS_F B
1003: where B.ORG_PAYMENT_METHOD_ID = T.ORG_PAYMENT_METHOD_ID

Line 1006: update PAY_ORG_PAYMENT_METHODS_F_TL T set (

1002: from PAY_ORG_PAYMENT_METHODS_F B
1003: where B.ORG_PAYMENT_METHOD_ID = T.ORG_PAYMENT_METHOD_ID
1004: );
1005:
1006: update PAY_ORG_PAYMENT_METHODS_F_TL T set (
1007: ORG_PAYMENT_METHOD_NAME
1008: ) = (select
1009: B.ORG_PAYMENT_METHOD_NAME
1010: from PAY_ORG_PAYMENT_METHODS_F_TL B

Line 1010: from PAY_ORG_PAYMENT_METHODS_F_TL B

1006: update PAY_ORG_PAYMENT_METHODS_F_TL T set (
1007: ORG_PAYMENT_METHOD_NAME
1008: ) = (select
1009: B.ORG_PAYMENT_METHOD_NAME
1010: from PAY_ORG_PAYMENT_METHODS_F_TL B
1011: where B.ORG_PAYMENT_METHOD_ID = T.ORG_PAYMENT_METHOD_ID
1012: and B.LANGUAGE = T.SOURCE_LANG)
1013: where (
1014: T.ORG_PAYMENT_METHOD_ID,

Line 1019: from PAY_ORG_PAYMENT_METHODS_F_TL SUBB, PAY_ORG_PAYMENT_METHODS_F_TL SUBT

1015: T.LANGUAGE
1016: ) in (select
1017: SUBT.ORG_PAYMENT_METHOD_ID,
1018: SUBT.LANGUAGE
1019: from PAY_ORG_PAYMENT_METHODS_F_TL SUBB, PAY_ORG_PAYMENT_METHODS_F_TL SUBT
1020: where SUBB.ORG_PAYMENT_METHOD_ID = SUBT.ORG_PAYMENT_METHOD_ID
1021: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1022: and (SUBB.ORG_PAYMENT_METHOD_NAME <> SUBT.ORG_PAYMENT_METHOD_NAME
1023: ));

Line 1025: insert into PAY_ORG_PAYMENT_METHODS_F_TL (

1021: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1022: and (SUBB.ORG_PAYMENT_METHOD_NAME <> SUBT.ORG_PAYMENT_METHOD_NAME
1023: ));
1024:
1025: insert into PAY_ORG_PAYMENT_METHODS_F_TL (
1026: ORG_PAYMENT_METHOD_ID,
1027: ORG_PAYMENT_METHOD_NAME,
1028: LAST_UPDATE_DATE,
1029: LAST_UPDATED_BY,

Line 1045: from PAY_ORG_PAYMENT_METHODS_F_TL B, FND_LANGUAGES L

1041: B.CREATED_BY,
1042: B.CREATION_DATE,
1043: L.LANGUAGE_CODE,
1044: B.SOURCE_LANG
1045: from PAY_ORG_PAYMENT_METHODS_F_TL B, FND_LANGUAGES L
1046: where L.INSTALLED_FLAG in ('I', 'B')
1047: and B.LANGUAGE = userenv('LANG')
1048: and not exists
1049: (select NULL

Line 1050: from PAY_ORG_PAYMENT_METHODS_F_TL T

1046: where L.INSTALLED_FLAG in ('I', 'B')
1047: and B.LANGUAGE = userenv('LANG')
1048: and not exists
1049: (select NULL
1050: from PAY_ORG_PAYMENT_METHODS_F_TL T
1051: where T.ORG_PAYMENT_METHOD_ID = B.ORG_PAYMENT_METHOD_ID
1052: and T.LANGUAGE = L.LANGUAGE_CODE);
1053: end ADD_LANGUAGE;
1054: -------------------------------------------------------------------------

Line 1173: UPDATE pay_org_payment_methods_f_tl

1169: X_OWNER in varchar2 ) is
1170: begin
1171: -- unique_chk(X_O_ORG_PAYMENT_METHOD_NAME,X_O_EFFECTIVE_START_DATE,X_O_EFFECTIVE_END_DATE);
1172: --
1173: UPDATE pay_org_payment_methods_f_tl
1174: SET ORG_PAYMENT_METHOD_NAME = nvl(X_ORG_PAYMENT_METHOD_NAME,ORG_PAYMENT_METHOD_NAME),
1175: last_update_date = SYSDATE,
1176: last_updated_by = decode(x_owner,'SEED',1,0),
1177: last_update_login = 0,