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

Line 87: from pay_org_payment_methods_f

83: select pay_org_payment_methods_s.nextval
84: from sys.dual;
85: cursor c2 is
86: select rowid
87: from pay_org_payment_methods_f
88: where org_payment_method_id = P_ORG_PAYMENT_METHOD_ID
89: and effective_start_date = P_EFFECTIVE_START_DATE
90: and effective_end_date = P_EFFECTIVE_END_DATE;
91: --

Line 98: insert into pay_org_payment_methods_f (

94: fetch c1 into P_ORG_PAYMENT_METHOD_ID;
95: close c1;
96: --
97: begin
98: insert into pay_org_payment_methods_f (
99: org_payment_method_id ,
100: effective_start_date ,
101: effective_end_date ,
102: business_group_id ,

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 324: pay_org_payment_methods_f ptm

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
328: AND (ptm.org_payment_method_id <> p_org_payment_method_id OR p_org_payment_method_id IS NULL)

Line 378: delete from pay_org_payment_methods_f o

374: ,p_org_eff_start_date => p_org_effective_start_date
375: ,p_org_eff_end_date => p_org_effective_end_date
376: );
377:
378: delete from pay_org_payment_methods_f o
379: where o.rowid = chartorowid(P_ROW_ID);
380: --
381: -- ********************************************************************************
382: --

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 389: from pay_org_payment_methods_f o

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
390: where o.ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
391: and o.rowid <> chartorowid(P_ROW_ID));
392: --
393: if sql%notfound then -- trap system errors during deletion

Line 473: from pay_org_payment_methods_f o

469: p_gl_error_ac_id number ) is
470: --
471: cursor OPM_CUR is
472: select *
473: from pay_org_payment_methods_f o
474: where o.rowid = chartorowid(P_ROW_ID)
475: FOR UPDATE OF ORG_PAYMENT_METHOD_ID NOWAIT;
476:
477: cursor PGA_CUR is

Line 849: update pay_org_payment_methods_f o

845: -- acedward 16/05/2000
846:
847: if p_dt_update_mode is not null then
848:
849: update pay_org_payment_methods_f o
850: set o.org_payment_method_id = P_ORG_PAYMENT_METHOD_ID,
851: o.effective_start_date = P_EFFECTIVE_START_DATE,
852: o.effective_end_date = P_EFFECTIVE_END_DATE,
853: o.business_group_id = P_BUSINESS_GROUP_ID,

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 1002: from PAY_ORG_PAYMENT_METHODS_F B

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
1004: );
1005:
1006: update PAY_ORG_PAYMENT_METHODS_F_TL T set (

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 1104: FROM pay_org_payment_methods_f

1100: is
1101: result varchar2(255);
1102: Begin
1103: SELECT count(*) INTO result
1104: FROM pay_org_payment_methods_f
1105: WHERE ORG_PAYMENT_METHOD_NAME = O_ORG_PAYMENT_METHOD_NAME
1106: and EFFECTIVE_START_DATE = O_EFFECTIVE_START_DATE
1107: and EFFECTIVE_END_DATE = O_EFFECTIVE_END_DATE
1108: and O_ORG_PAYMENT_METHOD_NAME is not NULL

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,

Line 1182: from pay_org_payment_methods_f

1178: source_lang = userenv('LANG')
1179: WHERE userenv('LANG') IN (language,source_lang)
1180: AND ORG_PAYMENT_METHOD_ID in
1181: (select ORG_PAYMENT_METHOD_ID
1182: from pay_org_payment_methods_f
1183: WHERE ORG_PAYMENT_METHOD_NAME = X_O_ORG_PAYMENT_METHOD_NAME
1184: and EFFECTIVE_START_DATE = X_O_EFFECTIVE_START_DATE
1185: and EFFECTIVE_END_DATE = X_O_EFFECTIVE_END_DATE
1186: and X_O_ORG_PAYMENT_METHOD_NAME is not NULL