APPS.OKL_RULE_EXTRACT_PVT dependencies on OKC_RULE_DEF_SOURCES_V

Line 69: --Cursor to get JTOT_OBJECT_CODE from OKC_RULE_DEF_SOURCES_V

65: x_object_code OUT NOCOPY VARCHAR2,
66: x_id1_col OUT NOCOPY VARCHAR2,
67: x_id2_col OUT NOCOPY VARCHAR2,
68: x_name_col OUT NOCOPY VARCHAR2) is
69: --Cursor to get JTOT_OBJECT_CODE from OKC_RULE_DEF_SOURCES_V
70: Cursor rule_source_curs is
71: SELECT rds.jtot_object_code object_code
72: FROM OKC_RULE_DEF_SOURCES_V rds
73: WHERE rds.rgr_rgd_code = p_rgd_code

Line 72: FROM OKC_RULE_DEF_SOURCES_V rds

68: x_name_col OUT NOCOPY VARCHAR2) is
69: --Cursor to get JTOT_OBJECT_CODE from OKC_RULE_DEF_SOURCES_V
70: Cursor rule_source_curs is
71: SELECT rds.jtot_object_code object_code
72: FROM OKC_RULE_DEF_SOURCES_V rds
73: WHERE rds.rgr_rgd_code = p_rgd_code
74: AND rds.rgr_rdf_code = p_rgs_code
75: AND rds.buy_or_sell = p_buy_or_sell
76: AND rds.object_id_number = decode(p_object_code,

Line 91: --Step 1 : Get the JTOT_OBJECT_CODE Name from OKC_RULE_DEF_SOURCES_V

87:
88: Begin
89: --initialize return status
90: x_return_status := OKL_API.G_RET_STS_SUCCESS;
91: --Step 1 : Get the JTOT_OBJECT_CODE Name from OKC_RULE_DEF_SOURCES_V
92: Open rule_source_curs;
93: Fetch rule_source_curs into rule_source_rec;
94: If rule_source_curs%NotFound Then
95: --dbms_output.put_line('Get_Jtot_Query : falied in getting rule_source');