DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2671: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2667: l_progress VARCHAR2(3) := '000';
2668: l_style_id NUMBER;
2669: l_src_template_id NUMBER;
2670: l_target_template_id NUMBER;
2671: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2672: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2673: l_to_pk1_value NUMBER;
2674: l_attr_group_tbl PO_TBL_VARCHAR30;
2675: x_return_status VARCHAR2(1);

Line 2672: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2668: l_style_id NUMBER;
2669: l_src_template_id NUMBER;
2670: l_target_template_id NUMBER;
2671: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2672: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2673: l_to_pk1_value NUMBER;
2674: l_attr_group_tbl PO_TBL_VARCHAR30;
2675: x_return_status VARCHAR2(1);
2676: x_msg_count NUMBER;

Line 2712: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ

2708: IF g_debug_stmt THEN
2709: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'l_src_template_id' || l_src_template_id );
2710: END IF;
2711:
2712: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ
2713: ('PO_LINE_ID',
2714: p_po_line_id_tbl(i) ),
2715: EGO_COL_NAME_VALUE_PAIR_OBJ
2716: ( 'DRAFT_ID', -1) );

Line 2739: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ

2735: po_debug.debug_var(p_log_head => g_log_head||l_api_name , p_progress => l_progress , p_name => 'l_attr_group_tbl' , p_value => l_attr_group_tbl );
2736: END IF;
2737:
2738: l_progress := '120';
2739: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ
2740: ( 'PO_LINE_ID', p_po_line_id_tbl(i) ),
2741: EGO_COL_NAME_VALUE_PAIR_OBJ
2742: ( 'DRAFT_ID',
2743: po_autocreate_params.g_draft_id));

Line 2862: x_from_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY

2858: IF x_attr_group_tbl.Count > 0 THEN
2859: l_progress := '060';
2860: PO_UDA_DATA_UTIL.Copy_User_Attrs
2861: ( x_template_id => l_template_id,
2862: x_from_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY
2863: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'PO_LINE_ID' ,
2864: p_po_line_id_tbl(i)),
2865: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2866: -1) ),

Line 2867: x_to_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY

2863: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'PO_LINE_ID' ,
2864: p_po_line_id_tbl(i)),
2865: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2866: -1) ),
2867: x_to_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY
2868: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'PO_LINE_ID' ,
2869: p_po_line_id_tbl(i)),
2870: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2871: po_autocreate_params.g_draft_id)),

Line 2912: x_from_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY

2908: IF x_attr_group_tbl.Count > 0 THEN
2909: l_progress := '090';
2910: PO_UDA_DATA_UTIL.Copy_User_Attrs
2911: ( x_template_id => l_template_id,
2912: x_from_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY
2913: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'LINE_LOCATION_ID',
2914: p_line_location_id_tbl(i)),
2915: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2916: -1) ),

Line 2917: x_to_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY

2913: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'LINE_LOCATION_ID',
2914: p_line_location_id_tbl(i)),
2915: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2916: -1) ),
2917: x_to_pk_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY
2918: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'LINE_LOCATION_ID',
2919: p_line_location_id_tbl(i)),
2920: EGO_COL_NAME_VALUE_PAIR_OBJ( 'DRAFT_ID' ,
2921: po_autocreate_params.g_draft_id)),