DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RST_PUB dependencies on OKL_SIF_RET_STRMS

Line 1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;

1135: l_strm_rec strm_rec_type;
1136:
1137: l_srsv_rec srsv_rec_type;
1138: l_srsv_tbl srsv_tbl_type;
1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1140: p_se_line_number NUMBER := 1;
1141: l_counter NUMBER := 0;
1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;
1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;

Line 1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;

1138: l_srsv_tbl srsv_tbl_type;
1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1140: p_se_line_number NUMBER := 1;
1141: l_counter NUMBER := 0;
1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;
1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;
1144:
1145: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1146: BEGIN

Line 1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1259: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1260: ---------------------------------------------------------------------------
1261:
1262: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 1273: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;

1269: ) IS
1270:
1271: p_api_version NUMBER := 1.0;
1272: x_id NUMBER;
1273: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1274: p_se_line_number NUMBER := 1;
1275: p_init_msg_list VARCHAR2(1) := 'F';
1276:
1277: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

Line 1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1421: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,

1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

Line 1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1578: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,

1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

Line 1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,

1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1589: ) IS
1590: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';