APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_SCOPES_S

Line 1551: insert into QPR_SCOPES(SCOPE_ID,PARENT_ENTITY_TYPE, PARENT_ID,

1547: g_prg_appl_id, g_prg_id, g_request_id);
1548: end loop;
1549:
1550: for rec_scope in c_scopes loop
1551: insert into QPR_SCOPES(SCOPE_ID,PARENT_ENTITY_TYPE, PARENT_ID,
1552: DIM_CODE, HIERARCHY_ID, LEVEL_ID,
1553: OPERATOR, SCOPE_VALUE, SCOPE_VALUE_DESC,
1554: CREATION_DATE,
1555: CREATED_BY, LAST_UPDATE_DATE,LAST_UPDATED_BY,

Line 1558: values(qpr_scopes_s.nextval, 'DATAMART', g_new_pp_id,

1554: CREATION_DATE,
1555: CREATED_BY, LAST_UPDATE_DATE,LAST_UPDATED_BY,
1556: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
1557: PROGRAM_ID, REQUEST_ID)
1558: values(qpr_scopes_s.nextval, 'DATAMART', g_new_pp_id,
1559: rec_scope.dim_code, rec_scope.hierarchy_id, rec_scope.level_id,
1560: rec_scope.operator, rec_scope.scope_value,
1561: rec_scope.scope_value_desc, g_sys_date,
1562: g_user_id, g_sys_date, g_user_id, g_login_id,