APPS.OKS_MASSCHANGE_PVT dependencies on OKC_CLASS_OPERATIONS_V

Line 68: okc_class_operations_v oco

64: AND okh.id not in(
65: SELECT ole.subject_chr_id
66: FROM okc_operation_instances_v oie,
67: okc_operation_lines_v ole,
68: okc_class_operations_v oco
69: WHERE oie.id = ole.oie_id
70: AND oie.id = :p_ctr_rec_oie_id
71: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
72: AND oas.sts_code = okh.sts_code

Line 108: okc_class_operations_v oco

104: AND okh.date_terminated is NULL
105: AND okh.id not in ( SELECT ole.subject_chr_id
106: FROM okc_operation_instances_v oie,
107: okc_operation_lines_v ole,
108: okc_class_operations_v oco
109: WHERE oie.id = ole.oie_id
110: AND oie.id = :p_ctr_rec_oie_id
111: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
112: AND oas.sts_code = okh.sts_code

Line 12561: SELECT ID from OKC_CLASS_OPERATIONS_V

12557: -------------------------------------------------------------------------
12558: ---Find the Class Operation ID to be used
12559: --------------------------------------------------------------------------
12560: CURSOR class_operations is
12561: SELECT ID from OKC_CLASS_OPERATIONS_V
12562: WHERE OPN_CODE = 'MASS_CHANGE' and CLS_CODE = 'SERVICE';
12563:
12564: BEGIN
12565: --dbms_output.put_line('Inside ..');

Line 13887: SELECT count(*) cnt FROM okc_class_operations_v

13883:
13884: PROCEDURE Create_Mschg_Class_Operation
13885: IS
13886: CURSOR Check_class_opn IS
13887: SELECT count(*) cnt FROM okc_class_operations_v
13888: WHERE opn_code = 'MASS_CHANGE'
13889: AND cls_code = 'SERVICE';
13890: CURSOR Get_max_id IS
13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;

Line 13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;

13887: SELECT count(*) cnt FROM okc_class_operations_v
13888: WHERE opn_code = 'MASS_CHANGE'
13889: AND cls_code = 'SERVICE';
13890: CURSOR Get_max_id IS
13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;
13892:
13893: l_opn_id Number;
13894: l_count Number := 0;
13895: BEGIN