80: X_USERTYPE_ID IN NUMBER,
81: X_TEMPLATE_ID IN NUMBER,
82: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
83: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
84: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
85: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
86: ) ;
87:
88: procedure ASSOCIATE_TEMPLATE(
81: X_TEMPLATE_ID IN NUMBER,
82: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
83: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
84: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
85: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
86: ) ;
87:
88: procedure ASSOCIATE_TEMPLATE(
89: X_USERTYPE_ID IN NUMBER,
122: X_SUBSCRIPTION_FLAG VARCHAR2,
123: X_DISPLAY_ORDER NUMBER,
124: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
125: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
126: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
127: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
128: );
129:
130: procedure UPDATE_SUBSCRIPTION_ASSIGNMENT(
123: X_DISPLAY_ORDER NUMBER,
124: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
125: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
126: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
127: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
128: );
129:
130: procedure UPDATE_SUBSCRIPTION_ASSIGNMENT(
131: X_USERTYPE_ID NUMBER,