DBA Data[Home] [Help]

APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_INSTANCES

Line 56: from qpr_instances

52:
53: else
54: begin
55: select instance_id into p_instance
56: from qpr_instances
57: where instance_id = p_instance_id;
58: exception
59: when others then
60: retcode := 2;

Line 94: from qpr_instances

90: begin
91:
92: if l_instance_id is null then
93: select count(*) into l_exist_instance
94: from qpr_instances
95: where instance_id = l_instance_type;
96:
97: if l_exist_instance = 0 then
98: Insert into qpr_instances ("INSTANCE_ID","INSTANCE_CODE","DBLINK",

Line 98: Insert into qpr_instances ("INSTANCE_ID","INSTANCE_CODE","DBLINK",

94: from qpr_instances
95: where instance_id = l_instance_type;
96:
97: if l_exist_instance = 0 then
98: Insert into qpr_instances ("INSTANCE_ID","INSTANCE_CODE","DBLINK",
99: "INSTANCE_TYPE",
100: "ENABLED_FLAG","CREATION_DATE","CREATED_BY","LAST_UPDATE_DATE",
101: "LAST_UPDATED_BY","LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
102: "PROGRAM_APPLICATION_ID","REQUEST_ID")