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 ,
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,
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)