APPS.JAI_OPEN_API_PKG dependencies on JAI_INTERFACE_LINES_ALL_S

Line 4429: pv_service_type_code IN JAI_INTERFACE_LINES_ALL.SERVICE_TYPE_CODE%TYPE,

4425: */
4426: PROCEDURE validate_service_type(
4427: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
4428: pn_trx_id IN JAI_INTERFACE_LINES_ALL.INTERNAL_TRX_ID%TYPE,
4429: pv_service_type_code IN JAI_INTERFACE_LINES_ALL.SERVICE_TYPE_CODE%TYPE,
4430: xn_err_flag IN OUT NOCOPY NUMBER
4431: )IS
4432:
4433: --Cursor define here

Line 8161: lv_st_invoice_num jai_interface_lines_all.ST_INV_NUMBER%TYPE;

8157: FROM JAI_INTERFACE_LINES_ALL
8158: WHERE internal_trx_id = ln_customer_trx_id
8159: AND nvl(st_inv_number,'###')<> '###';
8160:
8161: lv_st_invoice_num jai_interface_lines_all.ST_INV_NUMBER%TYPE;
8162: lv_st_tax_exists VARCHAR2(1);
8163: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
8164:
8165: --PROGRAM BLOCK BEGIN

Line 11407: ln_interface_line_id := JAI_INTERFACE_LINES_ALL_S.nextval;

11403: ln_interface_line_id := 0;
11404:
11405: IF(NVL(rec_interface_line.interface_line_id,-1) <= 0)THEN
11406:
11407: ln_interface_line_id := JAI_INTERFACE_LINES_ALL_S.nextval;
11408:
11409: --Mark line sequence no
11410: UPDATE jai_interface_lines_all
11411: SET interface_line_id = ln_interface_line_id