DBA Data[Home] [Help]

APPS.OKL_ISG_UTILS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 66: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%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,
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);

Line 83: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

79:
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);

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

Line 103: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

99: -- Performant APIs added which accept G_GET_K_INFO_CSR Record 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,

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