DBA Data[Home] [Help]

APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

66: l_can_edit_this_instance VARCHAR2(1);
67: l_token_table ERROR_HANDLER.Token_Tbl_Type;
68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

Line 71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

67: l_token_table ERROR_HANDLER.Token_Tbl_Type;
68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

Line 72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
76: l_failed_row_id_buffer VARCHAR2(32767);

Line 73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
76: l_failed_row_id_buffer VARCHAR2(32767);
77: l_failed_row_id_list VARCHAR2(32767);

Line 663: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

659: G_ITEM_NAME := 'ENG_CHANGE';
660: IF (l_prev_loop_org_id IS NULL) THEN
661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop l_prev_loop_org_id IS NULL', 1);
662:
663: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
664: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', attr_rec.CHANGE_ID)
665: );
666: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
667: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID));

Line 666: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

662:
663: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
664: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', attr_rec.CHANGE_ID)
665: );
666: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
667: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID));
668: p_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
669: p_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
670:

Line 961: p_line_pk_col_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

957: IF (l_prev_loop_org_id IS NULL ) THEN
958:
959: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside setting p_line_pk_col_name_value_pairs', 1);
960:
961: p_line_pk_col_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
962: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', attr_rec.CHANGE_LINE_ID)
963: );
964:
965: p_line_class_code_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 965: p_line_class_code_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

961: p_line_pk_col_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
962: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', attr_rec.CHANGE_LINE_ID)
963: );
964:
965: p_line_class_code_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
966: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID)
967:
968: );
969: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside intilizing attribute and data table ', 1);

Line 1302: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1298: l_change_id NUMBER;
1299: l_change_type_id NUMBER;
1300: l_can_edit_this_instance VARCHAR2(1);
1301: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1302: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1303: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1304: l_failed_row_id_buffer VARCHAR2(32767);
1305: l_failed_row_id_list VARCHAR2(32767);
1306: l_return_status VARCHAR2(1);

Line 1303: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1299: l_change_type_id NUMBER;
1300: l_can_edit_this_instance VARCHAR2(1);
1301: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1302: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1303: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1304: l_failed_row_id_buffer VARCHAR2(32767);
1305: l_failed_row_id_list VARCHAR2(32767);
1306: l_return_status VARCHAR2(1);
1307: l_errorcode NUMBER;

Line 1369: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1365: RAISE G_NO_CHANGE_TO_VALIDATE;
1366: else
1367: G_ITEM_NAME := 'ENG_CHANGE';
1368:
1369: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1370: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', l_change_id));
1371:
1372: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1373: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)

Line 1372: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1368:
1369: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1370: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', l_change_id));
1371:
1372: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1373: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)
1374: );
1375: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE
1376: -- attributes.

Line 1447: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1443: l_change_line_id NUMBER;
1444: l_change_type_id NUMBER;
1445: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1446: l_can_edit_this_instance VARCHAR2(1);
1447: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1448: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1449: l_failed_row_id_buffer VARCHAR2(32767);
1450: l_failed_row_id_list VARCHAR2(32767);
1451: l_return_status VARCHAR2(1);

Line 1448: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1444: l_change_type_id NUMBER;
1445: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1446: l_can_edit_this_instance VARCHAR2(1);
1447: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1448: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1449: l_failed_row_id_buffer VARCHAR2(32767);
1450: l_failed_row_id_list VARCHAR2(32767);
1451: l_return_status VARCHAR2(1);
1452: l_errorcode NUMBER;

Line 1514: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1510: RAISE G_NO_CHANGE_TO_VALIDATE;
1511: else
1512: G_ITEM_NAME := 'ENG_CHANGE_LINE';
1513:
1514: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1515: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', l_change_line_id)
1516: );
1517:
1518: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 1518: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1514: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1515: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', l_change_line_id)
1516: );
1517:
1518: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1519: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)
1520: );
1521:
1522: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE