[Home] [Help]
9789: --
9790: begin
9791: select instance_status_id
9792: into v_instance_status_id
9793: from CSI_INSTANCE_STATUSES
9794: where name = 'EXPIRED';
9795: exception
9796: when no_data_found then
9797: raise_application_error(-20000,'You need to setup an Expired Instance Status');
10198: END IF;
10199: --
10200: l_object_name := l_schema_name||'.CS_CUSTOMER_PRODUCTS_ALL_OLD cp';
10201: --
10202: l_sql_stmt := 'select terminated_flag,cp.customer_product_status_id from CSI_INSTANCE_STATUSES cis, '||l_object_name||' where cp.customer_product_id = :inst_id and cis.instance_status_id = cp.customer_product_status_id';
10203: --
10204: BEGIN -- First
10205: OPEN CSI_CUR;
10206: LOOP
10245: BEGIN -- Second Update
10246: begin
10247: select instance_status_id
10248: into v_instance_status_id
10249: from CSI_INSTANCE_STATUSES
10250: where name = 'EXPIRED';
10251: exception
10252: when no_data_found then
10253: raise_application_error(-20000,'You need to setup an Expired Instance Status');
10339: if v_status_id is NULL then
10340: v_status := nvl(FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS'), 'Latest');
10341: select instance_status_id
10342: into v_status_id
10343: from CSI_INSTANCE_STATUSES
10344: where name = v_status;
10345: end if;
10346:
10347: update CSI_ITEM_INSTANCES
12245: -- Get the LATEST Status ID. This will be used for all INV records.
12246: Begin
12247: select instance_status_id
12248: into v_ins_status_id
12249: from CSI_INSTANCE_STATUSES
12250: where name = 'Latest';
12251: Exception
12252: when no_data_found then
12253: v_err_msg := 'Status ID not found in CSI for Latest Status';
13673: -- Get the LATEST Status ID. This will be used for all INV records.
13674: Begin
13675: select instance_status_id
13676: into v_ins_status_id
13677: from CSI_INSTANCE_STATUSES
13678: where name = 'Latest';
13679: Exception
13680: when no_data_found then
13681: v_err_msg := 'Status ID not found in CSI for Latest Status';