APPS.OKL_ISG_UTILS_PVT dependencies on OKL_STRM_TYPE_B

Line 59: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

55:
56: PROCEDURE get_primary_stream_type(
57: p_khr_id IN NUMBER,
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:

Line 61: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

57: p_khr_id IN NUMBER,
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,

Line 67: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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,
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:

Line 69: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

65: p_khr_id IN NUMBER,
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,

Line 75: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

71:
72: PROCEDURE get_dependent_stream_type(
73: p_khr_id IN NUMBER,
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:

Line 77: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

73: p_khr_id IN NUMBER,
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(

Line 84: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

80:
81: PROCEDURE get_dependent_stream_type(
82: p_khr_id IN NUMBER,
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:

Line 86: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

82: p_khr_id IN NUMBER,
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,

Line 92: p_primary_sty_id IN okl_strm_type_b.ID%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,
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);

Line 93: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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,
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:

Line 95: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

91: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%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

Line 104: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

100: -- as an additional parameter instead of running repeatedly.
101: PROCEDURE get_dep_stream_type(
102: p_khr_id IN NUMBER,
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);

Line 106: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

102: p_khr_id IN NUMBER,
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(

Line 113: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

109:
110: PROCEDURE get_dep_stream_type(
111: p_khr_id IN NUMBER,
112: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%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,

Line 114: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

110: PROCEDURE get_dep_stream_type(
111: p_khr_id IN NUMBER,
112: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%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);

Line 116: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

112: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%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: