88: X_SUBSCRIPTION_ID IN NUMBER,
89: X_TEMPLATE_ID IN NUMBER,
90: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
91: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
92: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
93: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
94: );
95:
96: procedure UPDATE_TEMPLATE_ASSIGNMENT(
89: X_TEMPLATE_ID IN NUMBER,
90: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
91: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
92: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
93: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
94: );
95:
96: procedure UPDATE_TEMPLATE_ASSIGNMENT(
97: X_SUBSCRIPTION_ID IN NUMBER,