[Home] [Help]
470: end TRANSLATE_ROW;
471:
472: FUNCTION IS_TEMPLATE_ASSIGNED(X_SUBSCRIPTION_ID NUMBER, X_TEMPLATE_ID NUMBER) RETURN BOOLEAN IS
473: l_dummy NUMBER;
474: CURSOR C IS SELECT SUBSCRIPTION_ID FROM JTF_UM_SUBSCRIPTION_TMPL WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID AND TEMPLATE_ID = X_TEMPLATE_ID AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
475: begin
476: open c;
477: fetch c into l_dummy;
478: if(c%NOTFOUND) then
488: X_SUBSCRIPTION_ID IN NUMBER
489: ) is
490: begin
491:
492: UPDATE JTF_UM_SUBSCRIPTION_TMPL SET
493: EFFECTIVE_END_DATE = SYSDATE,
494: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
495: LAST_UPDATE_DATE= SYSDATE
496: WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID ;
506: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
507: ) is
508: begin
509:
510: INSERT INTO JTF_UM_SUBSCRIPTION_TMPL(
511: SUBSCRIPTION_ID,
512: TEMPLATE_ID,
513: EFFECTIVE_START_DATE,
514: EFFECTIVE_END_DATE,
551: X_LAST_UPDATED_BY IN NUMBER,
552: X_LAST_UPDATE_LOGIN IN NUMBER
553: ) is
554: begin
555: update JTF_UM_SUBSCRIPTION_TMPL
556: set EFFECTIVE_END_DATE=X_EFFECTIVE_END_DATE,
557: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
558: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
559: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
586: -- end if;
587:
588: select count(*)
589: into h_record_exists
590: from jtf_UM_SUBSCRIPTION_TMPL
591: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
592: and TEMPLATE_ID = X_TEMPLATE_ID
593: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
594:
615: -- there is a row for this app_id and this app_short_name
616: -- Exception is thrown otherwise.
617: select LAST_UPDATED_BY, LAST_UPDATE_DATE
618: into db_luby, db_ludate
619: FROM JTF_UM_SUBSCRIPTION_TMPL
620: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
621: and TEMPLATE_ID = X_TEMPLATE_ID
622: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
623: