DBA Data[Home] [Help]

APPS.PON_EMD_PAYMENT_TYPES_UTIL dependencies on PON_EMD_PAYMENT_TYPES_ALL

Line 39: INSERT INTO PON_EMD_PAYMENT_TYPES_ALL

35:
36: L_ORG_ID := X_ORG_ID;
37:
38:
39: INSERT INTO PON_EMD_PAYMENT_TYPES_ALL
40: (
41: PAYMENT_TYPE_CODE ,
42: ORG_ID ,
43: START_DATE_ACTIVE ,

Line 168: UPDATE PON_EMD_PAYMENT_TYPES_ALL

164: PAYMENT_TYPE_CODE = X_PAYMENT_TYPE_CODE
165: AND
166: USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
167:
168: UPDATE PON_EMD_PAYMENT_TYPES_ALL
169: SET
170: PAYMENT_TYPE_CODE = X_PAYMENT_TYPE_CODE,
171: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
172: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 258: PON_EMD_PAYMENT_TYPES_ALL

254: L_USER_ID :=FND_LOAD_UTIL.OWNER_ID(X_OWNER);
255:
256: SELECT ORG_ID,LAST_UPDATED_BY INTO L_ORG_ID,L_DB_USER_ID
257: FROM
258: PON_EMD_PAYMENT_TYPES_ALL
259: WHERE
260: PAYMENT_TYPE_CODE=X_PAYMENT_TYPE_CODE
261: AND
262: Nvl(ORG_ID,-1)=Nvl(X_ORG_ID,-1)