APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_NUM_TBL_TYPE

Line 2444: aw_user_list zpb_num_tbl_type;

2440: l_role_has_users VARCHAR2(1);
2441: l_position BINARY_INTEGER;
2442: l_pattern_position BINARY_INTEGER;
2443:
2444: aw_user_list zpb_num_tbl_type;
2445:
2446: -- Auto distribution
2447: CURSOR param_type_csr IS
2448: SELECT value

Line 2545: aw_user_list := zpb_num_tbl_type(0);

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);
2546: END IF;
2547:
2548: IF l_lob_length > 0 THEN
2549: LOOP

Line 2575: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,

2571: -- Join the fnd user to get the user names
2572: FOR fnd_rec IN
2573: (select column_value , fndu.user_name user_name
2574: from
2575: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
2576: fnd_user fndu
2577: where fndu.user_id = aw_users.column_value
2578: )
2579: LOOP

Line 2650: aw_user_list := zpb_num_tbl_type(0);

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;
2652:
2653: IF l_lob_length > 0 THEN
2654: LOOP

Line 2679: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,

2675:
2676: FOR fnd_rec IN
2677: (select column_value , fndu.user_name user_name
2678: from
2679: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
2680: fnd_user fndu
2681: where fndu.user_id = aw_users.column_value
2682: )
2683: LOOP

Line 2981: aw_user_list zpb_num_tbl_type;

2977:
2978: l_pattern VARCHAR2(1);
2979: l_position BINARY_INTEGER;
2980: l_pattern_position BINARY_INTEGER;
2981: aw_user_list zpb_num_tbl_type;
2982:
2983: BEGIN
2984:
2985: SAVEPOINT Set_Submit_Ntf_Recipients;

Line 3045: aw_user_list := zpb_num_tbl_type(0);

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 ;
3047:
3048: IF l_lob_length > 0 THEN
3049: LOOP

Line 3075: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,

3071: -- Join the fnd user to get the user names
3072: FOR fnd_rec IN
3073: (select column_value , fndu.user_name user_name
3074: from
3075: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
3076: fnd_user fndu
3077: where fndu.user_id = aw_users.column_value
3078: )
3079: LOOP