3441: P_LAST_UPDATE_DATE,
3442: P_LAST_UPDATE_LOGIN,
3443: 'OWN_ONLY');
3444:
3445: INSERT INTO zx_subscription_details
3446: (SUBSCRIPTION_DETAIL_ID,
3447: SUBSCRIPTION_OPTION_ID,
3448: FIRST_PTY_ORG_ID,
3449: PARENT_FIRST_PTY_ORG_ID,
3455: CREATION_DATE,
3456: LAST_UPDATED_BY,
3457: LAST_UPDATE_DATE,
3458: LAST_UPDATE_LOGIN)
3459: VALUES(zx_subscription_details_s.nextval,
3460: l_sub_opt_id,
3461: l_pty_org_id,
3462: l_pty_org_id,
3463: 'VFC',
3469: P_LAST_UPDATED_BY,
3470: P_LAST_UPDATE_DATE,
3471: P_LAST_UPDATE_LOGIN);
3472:
3473: INSERT INTO zx_subscription_details
3474: (SUBSCRIPTION_DETAIL_ID,
3475: SUBSCRIPTION_OPTION_ID,
3476: FIRST_PTY_ORG_ID,
3477: PARENT_FIRST_PTY_ORG_ID,
3483: CREATION_DATE,
3484: LAST_UPDATED_BY,
3485: LAST_UPDATE_DATE,
3486: LAST_UPDATE_LOGIN)
3487: VALUES(zx_subscription_details_s.nextval,
3488: l_sub_opt_id,
3489: l_pty_org_id,
3490: -99,
3491: 'VFR',