APPS.OKL_ISG_UTILS_PVT dependencies on OKL_STRM_TYPE_V

Line 62: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);

58: p_pdt_id IN NUMBER,
59: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
62: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
63:
64: PROCEDURE get_primary_stream_type(
65: p_khr_id IN NUMBER,
66: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

Line 70: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);

66: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
67: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
70: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
71:
72: PROCEDURE get_dependent_stream_type(
73: p_khr_id IN NUMBER,
74: p_pdt_id IN NUMBEr,

Line 78: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);

74: p_pdt_id IN NUMBEr,
75: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
78: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
79:
80:
81: PROCEDURE get_dependent_stream_type(
82: p_khr_id IN NUMBER,

Line 87: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);

83: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
84: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
87: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
88:
89: PROCEDURE get_dependent_stream_type(
90: p_khr_id IN NUMBER,
91: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

Line 96: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);

92: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
93: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
96: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
97:
98: -- Added by RGOOTY: Start
99: -- Performant APIs added which accept G_GET_K_INFO_CSR Record type
100: -- as an additional parameter instead of running repeatedly.

Line 107: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,

103: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
104: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
107: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
108: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE);
109:
110: PROCEDURE get_dep_stream_type(
111: p_khr_id IN NUMBER,

Line 117: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,

113: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
114: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
117: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
118: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE);
119: -- Added by RGOOTY: End
120:
121: