APPS.JTF_PLSQL_API dependencies on JTF_PLSQL_API

Line 1: PACKAGE BODY JTF_PLSQL_API as

1: PACKAGE BODY JTF_PLSQL_API as
2: /* $Header: JTFPAPIB.pls 115.2 2000/08/17 00:09:15 pkm ship $ */
3:
4: --
5: -- NAME

Line 6: -- JTF_PLSQL_API

2: /* $Header: JTFPAPIB.pls 115.2 2000/08/17 00:09:15 pkm ship $ */
3:
4: --
5: -- NAME
6: -- JTF_PLSQL_API
7: --
8: -- HISTORY
9: -- 08/11/99 AWU CREATED(as AS_UTILITY)
10: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)

Line 10: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)

6: -- JTF_PLSQL_API
7: --
8: -- HISTORY
9: -- 08/11/99 AWU CREATED(as AS_UTILITY)
10: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)
11: --
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PLSQL_API';
14: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpapib.pls';

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PLSQL_API';

9: -- 08/11/99 AWU CREATED(as AS_UTILITY)
10: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)
11: --
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PLSQL_API';
14: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpapib.pls';
15:
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 486: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type,

482: END IF;
483: END Set_Message;
484:
485: PROCEDURE Gen_Flexfield_Where(
486: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type,
487: x_flex_where_clause OUT VARCHAR2) IS
488: l_flex_where_cl VARCHAR2(2000) := NULL;
489: BEGIN
490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 492: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: begin');

488: l_flex_where_cl VARCHAR2(2000) := NULL;
489: BEGIN
490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
491: null;
492: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: begin');
493: END IF;
494:
495: FOR i IN 1..p_flex_where_tbl_type.count LOOP
496: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 506: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: end');

502: x_flex_where_clause := l_flex_where_cl;
503:
504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
505: null;
506: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: end');
507: END IF;
508: END;
509:
510: PROCEDURE Bind_Flexfield_Where(

Line 512: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type) IS

508: END;
509:
510: PROCEDURE Bind_Flexfield_Where(
511: p_cursor_id IN NUMBER,
512: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type) IS
513: BEGIN
514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
515: null;
516: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: begin');

Line 516: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: begin');

512: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type) IS
513: BEGIN
514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
515: null;
516: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: begin');
517: END IF;
518:
519: FOR i IN 1..p_flex_where_tbl_type.count LOOP
520: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 529: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: end');

525: END LOOP;
526:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
528: null;
529: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: end');
530: END IF;
531: END;
532:
533:

Line 534: END JTF_PLSQL_API;

530: END IF;
531: END;
532:
533:
534: END JTF_PLSQL_API;