33: /****************************************************************
34: * Obtain a group_id
35: ****************************************************************/
36: where_num := 50;
37: SELECT wip_transactions_s.nextval
38: INTO l_group_id
39: FROM dual;
40:
41: /****************************************************************
65: ACCT_PERIOD_ID, TRANSACTION_TYPE,
66: TRANSACTION_DATE, GROUP_ID,
67: LINE_ID)
68: SELECT
69: wip_transactions_s.nextval, SYSDATE,
70: i_user_id, SYSDATE,
71: i_user_id, i_login_id,
72: 2, 2,
73: i_org_id, b.wip_entity_id,
358: ACCT_PERIOD_ID, TRANSACTION_TYPE,
359: TRANSACTION_DATE, GROUP_ID,
360: LINE_ID)
361: SELECT
362: wip_transactions_s.nextval, SYSDATE,
363: i_user_id, SYSDATE,
364: i_user_id, i_login_id,
365: 2, 2,
366: i_org_id, wri.wip_entity_id,