1235: p_new_chr_id IN NUMBER,
1236: x_return_status OUT NOCOPY VARCHAR2)
1237: IS
1238: ctr NUMBER :=1;
1239: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1240: x_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1241: l_return_status Varchar2(1);
1242: l_msg_count Number;
1243: l_msg_data Varchar2(2000);
1236: x_return_status OUT NOCOPY VARCHAR2)
1237: IS
1238: ctr NUMBER :=1;
1239: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1240: x_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1241: l_return_status Varchar2(1);
1242: l_msg_count Number;
1243: l_msg_data Varchar2(2000);
1244: l_api_version Number := 1;
1281: END LOOP;
1282:
1283: IF l_scrv_tbl.COUNT >0
1284: THEN
1285: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
1286: p_api_version => l_api_version,
1287: x_return_status => l_return_status,
1288: x_msg_count => l_msg_count,
1289: x_msg_data => l_msg_data,
1333: p_new_chr_id IN NUMBER,
1334: x_return_status OUT NOCOPY VARCHAR2)
1335: IS
1336: ctr NUMBER :=1;
1337: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1338: x_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1339: l_return_status Varchar2(1);
1340: l_msg_count Number;
1341: l_msg_data Varchar2(2000);
1334: x_return_status OUT NOCOPY VARCHAR2)
1335: IS
1336: ctr NUMBER :=1;
1337: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1338: x_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1339: l_return_status Varchar2(1);
1340: l_msg_count Number;
1341: l_msg_data Varchar2(2000);
1342: l_api_version Number := 1;
1395:
1396:
1397: IF l_scrv_tbl.COUNT >0 THEN
1398:
1399: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
1400: p_api_version => l_api_version,
1401: x_return_status => l_return_status,
1402: x_msg_count => l_msg_count,
1403: x_msg_data => l_msg_data,