eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_DC_OBJECTS_PVT dependencies on DBMS_LOB

Line 1598: l_lob_length := dbms_lob.getlength(l_user_id_clob);

1594: p_resp_key => l_resp_key,
1595: x_user_id_clob => l_user_id_clob);
1596:
1597: l_position:= 1;
1598: l_lob_length := dbms_lob.getlength(l_user_id_clob);
1599:
1600: IF l_lob_length > 0 THEN
1601: LOOP
1602: l_pattern_position :=

Line 1603: DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);

1599:
1600: IF l_lob_length > 0 THEN
1601: LOOP
1602: l_pattern_position :=
1603: DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);
1604:
1605: IF l_pattern_position = 0 THEN
1606: l_amt := l_lob_length - l_position + 1;
1607: ELSE

Line 1611: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);

1607: ELSE
1608: l_amt := l_pattern_position - l_position;
1609: END IF;
1610:
1611: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);
1612:
1613: l_user_id := to_number(l_buffer);
1614: -- Check duplicates
1615: OPEN check_exist_csr;

Line 2066: l_lob_length := dbms_lob.getlength(l_user_id_clob);

2062: p_resp_key => l_resp_key,
2063: x_user_id_clob => l_user_id_clob);
2064:
2065: l_position:= 1;
2066: l_lob_length := dbms_lob.getlength(l_user_id_clob);
2067:
2068: IF l_lob_length > 0 THEN
2069: LOOP
2070: l_pattern_position :=

Line 2071: DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);

2067:
2068: IF l_lob_length > 0 THEN
2069: LOOP
2070: l_pattern_position :=
2071: DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);
2072:
2073: IF l_pattern_position = 0 THEN
2074: l_amt := l_lob_length - l_position + 1;
2075: ELSE

Line 2079: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);

2075: ELSE
2076: l_amt := l_pattern_position - l_position;
2077: END IF;
2078:
2079: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);
2080:
2081: l_user_id := to_number(l_buffer);
2082:
2083: -- Check whether the distribution exists already

Line 2541: l_lob_length := dbms_lob.getlength(l_user_id_clob);

2537: x_user_id_clob => l_user_id_clob);
2538:
2539: l_ind := 1;
2540: l_position:= 1;
2541: l_lob_length := dbms_lob.getlength(l_user_id_clob);
2542:
2543: -- Parse the clob and put the ids in a tab type object
2544: IF l_lob_length > 0 THEN
2545: aw_user_list := zpb_num_tbl_type(0);

Line 2550: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);

2546: END IF;
2547:
2548: IF l_lob_length > 0 THEN
2549: LOOP
2550: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);
2551:
2552: IF l_pattern_position = 0 THEN
2553: l_amt := l_lob_length - l_position+1;
2554: ELSE

Line 2558: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);

2554: ELSE
2555: l_amt := l_pattern_position - l_position;
2556: END IF;
2557:
2558: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);
2559: aw_user_list.extend;
2560: aw_user_list(l_ind):= to_number(l_buffer);
2561: l_ind:= l_ind+1;
2562:

Line 2647: l_lob_length := dbms_lob.getlength(l_user_id_clob);

2643:
2644: -- Parse the clob and put the ids in a tab type object
2645: l_ind := 1;
2646: l_position:= 1;
2647: l_lob_length := dbms_lob.getlength(l_user_id_clob);
2648:
2649: IF l_lob_length > 0 THEN
2650: aw_user_list := zpb_num_tbl_type(0);
2651: END IF;

Line 2655: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);

2651: END IF;
2652:
2653: IF l_lob_length > 0 THEN
2654: LOOP
2655: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);
2656:
2657: IF l_pattern_position = 0 THEN
2658: l_amt := l_lob_length - l_position+1;
2659: ELSE

Line 2663: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);

2659: ELSE
2660: l_amt := l_pattern_position - l_position;
2661: END IF;
2662:
2663: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);
2664: aw_user_list.extend;
2665: aw_user_list(l_ind):= to_number(l_buffer);
2666: l_ind:= l_ind+1;
2667:

Line 3042: l_lob_length := dbms_lob.getlength(l_user_id_clob);

3038:
3039: -- Parse the clob and put the ids in a tab type object
3040: l_ind := 1;
3041: l_position:= 1;
3042: l_lob_length := dbms_lob.getlength(l_user_id_clob);
3043:
3044: IF (l_lob_length > 0) THEN
3045: aw_user_list := zpb_num_tbl_type(0);
3046: END IF ;

Line 3050: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);

3046: END IF ;
3047:
3048: IF l_lob_length > 0 THEN
3049: LOOP
3050: l_pattern_position := DBMS_LOB.INSTR(l_user_id_clob, l_pattern, l_position, 1);
3051:
3052: IF l_pattern_position = 0 THEN
3053: l_amt := l_lob_length - l_position+1;
3054: ELSE

Line 3058: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);

3054: ELSE
3055: l_amt := l_pattern_position - l_position;
3056: END IF;
3057:
3058: dbms_lob.read (l_user_id_clob, l_amt, l_position, l_buffer);
3059: aw_user_list.extend;
3060: aw_user_list(l_ind):= to_number(l_buffer);
3061: l_ind:= l_ind+1;
3062: