APPS.PON_EMD_PAYMENT_TYPES_UTIL dependencies on PON_EMD_PAYMENT_TYPES_TL

Line 78: INSERT INTO PON_EMD_PAYMENT_TYPES_TL

74: X_PROGRAM_ID ,
75: X_PROGRAM_UPDATE_DATE
76: );
77:
78: INSERT INTO PON_EMD_PAYMENT_TYPES_TL
79: (
80: PAYMENT_TYPE_CODE ,
81: ORG_ID ,
82: NAME ,

Line 119: PON_EMD_PAYMENT_TYPES_TL T

115: AND NOT EXISTS
116: (
117: SELECT 1
118: FROM
119: PON_EMD_PAYMENT_TYPES_TL T
120: WHERE
121: T.PAYMENT_TYPE_CODE = X_PAYMENT_TYPE_CODE
122: AND
123: T.LANGUAGE = L.LANGUAGE_CODE

Line 152: UPDATE PON_EMD_PAYMENT_TYPES_TL

148: ) IS
149: BEGIN
150:
151:
152: UPDATE PON_EMD_PAYMENT_TYPES_TL
153: SET
154: NAME = X_NAME,
155: DESCRIPTION = X_DESCRIPTION,
156: REFUND_PAYMENT_METHOD = X_REFUND_PAYMENT_METHOD,

Line 205: UPDATE PON_EMD_PAYMENT_TYPES_TL

201: L_USER_ID NUMBER :=0;
202: BEGIN
203: L_USER_ID :=FND_LOAD_UTIL.OWNER_ID(X_OWNER); --SEED DATA VERSION CHANGES
204:
205: UPDATE PON_EMD_PAYMENT_TYPES_TL
206: SET
207: ORG_ID = X_ORG_ID,
208: PAYMENT_TYPE_CODE = X_PAYMENT_TYPE_CODE,
209: NAME = X_NAME,

Line 334: INSERT INTO PON_EMD_PAYMENT_TYPES_TL

330: PROCEDURE add_language IS
331:
332: BEGIN
333:
334: INSERT INTO PON_EMD_PAYMENT_TYPES_TL
335: (
336: PAYMENT_TYPE_CODE ,
337: ORG_ID ,
338: NAME ,

Line 368: FROM PON_EMD_PAYMENT_TYPES_TL EMDTL1,

364: EMDTL1.REQUEST_ID,
365: EMDTL1.PROGRAM_UPDATE_DATE,
366: LANG.LANGUAGE_CODE,
367: EMDTL1.SOURCE_LANG
368: FROM PON_EMD_PAYMENT_TYPES_TL EMDTL1,
369: FND_LANGUAGES LANG
370: WHERE
371: EMDTL1.LANGUAGE=UserEnv('LANG')
372: AND

Line 374: AND NOT EXISTS (SELECT NULL FROM PON_EMD_PAYMENT_TYPES_TL EMDTL2

370: WHERE
371: EMDTL1.LANGUAGE=UserEnv('LANG')
372: AND
373: LANG.INSTALLED_FLAG IN ('I', 'B')
374: AND NOT EXISTS (SELECT NULL FROM PON_EMD_PAYMENT_TYPES_TL EMDTL2
375: WHERE
376: EMDTL2.ORG_ID=EMDTL1.ORG_ID
377: AND
378: EMDTL2.PAYMENT_TYPE_CODE=EMDTL1.PAYMENT_TYPE_CODE