APPS.OKE_FORM_PVT dependencies on OKE_K_PRINT_FORMS

Line 417: FROM OKE_K_PRINT_FORMS a

413: ATTRIBUTE14 ,
414: ATTRIBUTE15
415:
416:
417: FROM OKE_K_PRINT_FORMS a
418: WHERE
419: (a.K_HEADER_ID = chr_id)AND(a.PRINT_FORM_CODE=pfm_cd)
420: AND(
421: ((a.K_LINE_ID IS NULL)AND(cle_id IS NULL)) OR

Line 622: INSERT INTO OKE_K_PRINT_FORMS(

618: RAISE OKE_API.G_EXCEPTION_ERROR;
619: END IF;
620:
621:
622: INSERT INTO OKE_K_PRINT_FORMS(
623:
624: K_HEADER_ID ,
625: K_LINE_ID ,
626: PRINT_FORM_CODE ,

Line 1079: UPDATE OKE_K_PRINT_FORMS

1075: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'update base table');
1077: END IF;
1078:
1079: UPDATE OKE_K_PRINT_FORMS
1080: SET
1081: CREATION_DATE = l_def_form_rec.CREATION_DATE,
1082: CREATED_BY = l_def_form_rec.CREATED_BY,
1083: LAST_UPDATE_DATE = l_def_form_rec.LAST_UPDATE_DATE,

Line 1245: p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE

1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,
1244: p_cle_id IN NUMBER,
1245: p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE
1246: ) IS
1247:
1248: l_api_version CONSTANT NUMBER := 1;
1249: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';

Line 1267: DELETE FROM OKE_K_PRINT_FORMS

1263: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1264: RAISE OKE_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:
1267: DELETE FROM OKE_K_PRINT_FORMS
1268: WHERE K_LINE_ID = p_cle_id AND PRINT_FORM_CODE = p_pfm_cd;
1269:
1270: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1271:

Line 1312: p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE

1308: x_return_status OUT NOCOPY VARCHAR2,
1309: x_msg_count OUT NOCOPY NUMBER,
1310: x_msg_data OUT NOCOPY VARCHAR2,
1311: p_chr_id IN NUMBER,
1312: p_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE
1313: ) IS
1314:
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';

Line 1334: DELETE FROM OKE_K_PRINT_FORMS

1330: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1331: RAISE OKE_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:
1334: DELETE FROM OKE_K_PRINT_FORMS
1335: WHERE (K_HEADER_ID=p_chr_id) AND (PRINT_FORM_CODE=p_pfm_cd) AND (K_LINE_ID IS NULL);
1336:
1337: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1338:

Line 1709: l_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE;

1705: l_row_notfound BOOLEAN := FALSE;
1706:
1707: l_chr_id NUMBER;
1708: l_cle_id NUMBER;
1709: l_pfm_cd OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE;
1710:
1711: E_Resource_Busy EXCEPTION;
1712: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1713:

Line 1716: SELECT k_header_id,k_line_id,print_form_code FROM oke_k_print_forms a

1712: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1713:
1714:
1715: CURSOR lock_csr (p IN form_rec_type) IS
1716: SELECT k_header_id,k_line_id,print_form_code FROM oke_k_print_forms a
1717: WHERE
1718: (a.K_HEADER_ID = p.K_HEADER_ID)AND(a.PRINT_FORM_CODE=p.PRINT_FORM_CODE)
1719: AND(
1720: ((a.K_LINE_ID IS NULL)AND(p.K_LINE_ID IS NULL)) OR