DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_PARAMS_TABLE

Line 76: | INTO JTF_PF_PARAMS_TABLE

72: END writePFObjectTable;
73:
74: /*============================================================================================================
75: | Writes THE Page flow data coming IN FROM THE JAVA layer INTO Advanced Queue
76: | INTO JTF_PF_PARAMS_TABLE
77: | This IS an autonomous TRANSACTION i.e. It does NOT matter whether THE parent TRANSACTION
78: | commited OR rolled back , this TRANSACTION will COMMIT IF ALL goes well
79: ============================================================================================================*/
80: PROCEDURE writePFObject(obj JTF_PF_PAGE_OBJECT,write_to_jtf INTEGER,tech_stack VARCHAR2, track_purpose VARCHAR2, dbdate OUT NOCOPY DATE) IS

Line 114: | INTO JTF_PF_PARAMS_TABLE |

110: END writePFObject;
111:
112: /* ============================================================================================================
113: | Converts THE param names AND param VALUES, coming IN AS 2 seperate arrays, FROM THE JAVA layer, |
114: | INTO JTF_PF_PARAMS_TABLE |
115: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
116: ===============================================================================================================*/
117: FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
118: RETURN JTF_PF_PARAMS_TABLE IS

Line 118: RETURN JTF_PF_PARAMS_TABLE IS

114: | INTO JTF_PF_PARAMS_TABLE |
115: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
116: ===============================================================================================================*/
117: FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
118: RETURN JTF_PF_PARAMS_TABLE IS
119: params JTF_PF_PARAMS_TABLE := JTF_PF_PARAMS_TABLE();
120: BEGIN
121: FOR i IN 1..paramSz LOOP
122: params.EXTEND;

Line 119: params JTF_PF_PARAMS_TABLE := JTF_PF_PARAMS_TABLE();

115: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
116: ===============================================================================================================*/
117: FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
118: RETURN JTF_PF_PARAMS_TABLE IS
119: params JTF_PF_PARAMS_TABLE := JTF_PF_PARAMS_TABLE();
120: BEGIN
121: FOR i IN 1..paramSz LOOP
122: params.EXTEND;
123: params(i) := JTF_PF_NVPAIR(paramNames(i),paramValues(i));

Line 147: FUNCTION GetParamString(params JTF_PF_PARAMS_TABLE)

143: /* ========================================================================
144: | Converts THE param names AND param VALUES, |
145: | coming IN AS an ARRAY OF NVPAIRS INTO a CLOB FOR clickstream support |
146: ===========================================================================*/
147: FUNCTION GetParamString(params JTF_PF_PARAMS_TABLE)
148: RETURN CLOB IS
149: paramCLOB CLOB;
150: paramV VARCHAR(32767);
151: nv JTF_PF_NVPAIR;

Line 614: params JTF_PF_PARAMS_TABLE;

610: END synchronize_pageflow_data;
611:
612: FUNCTION GetParamNVs (po_id INTEGER)
613: RETURN JTF_VARCHAR2_TABLE_4000 IS
614: params JTF_PF_PARAMS_TABLE;
615: paramSz NUMBER;
616: nv JTF_PF_NVPAIR;
617: pname JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
618: CURSOR cur(poid IN INTEGER) IS

Line 648: FUNCTION GetParamNames (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)

644: END LOOP;
645: RETURN pname;
646: END;
647:
648: FUNCTION GetParamNames (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
649: RETURN JTF_VARCHAR2_TABLE_300 IS
650: nv JTF_PF_NVPAIR;
651: pname JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
652: BEGIN

Line 661: FUNCTION GetParamValues (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)

657: END LOOP;
658: RETURN pname;
659: END;
660:
661: FUNCTION GetParamValues (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
662: RETURN JTF_VARCHAR2_TABLE_4000 IS
663: nv JTF_PF_NVPAIR;
664: pval JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
665: BEGIN