DBA Data[Home] [Help]

APPS.PO_UDA_AUTOCREATE_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 1441: EGO_COL_NAME_VALUE_PAIR_OBJ(

1437: IF x_pk2_col_name IS NOT NULL AND x_pk2_value IS NOT NULL
1438: THEN
1439:
1440: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1441: EGO_COL_NAME_VALUE_PAIR_OBJ(
1442: x_pk1_col_name, x_pk1_value
1443: ),
1444: EGO_COL_NAME_VALUE_PAIR_OBJ(
1445: x_pk2_col_name, x_pk2_value

Line 1444: EGO_COL_NAME_VALUE_PAIR_OBJ(

1440: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1441: EGO_COL_NAME_VALUE_PAIR_OBJ(
1442: x_pk1_col_name, x_pk1_value
1443: ),
1444: EGO_COL_NAME_VALUE_PAIR_OBJ(
1445: x_pk2_col_name, x_pk2_value
1446: ));
1447:
1448: ELSE

Line 1450: EGO_COL_NAME_VALUE_PAIR_OBJ(

1446: ));
1447:
1448: ELSE
1449: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1450: EGO_COL_NAME_VALUE_PAIR_OBJ(
1451: x_pk1_col_name, x_pk1_value
1452: ));
1453: END IF;
1454:

Line 1456: EGO_COL_NAME_VALUE_PAIR_OBJ(

1452: ));
1453: END IF;
1454:
1455: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1456: EGO_COL_NAME_VALUE_PAIR_OBJ(
1457: p_to_pk1_col_name,p_to_pk1_value
1458: ),
1459: EGO_COL_NAME_VALUE_PAIR_OBJ(
1460: 'DRAFT_ID',g_draft_id));

Line 1459: EGO_COL_NAME_VALUE_PAIR_OBJ(

1455: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1456: EGO_COL_NAME_VALUE_PAIR_OBJ(
1457: p_to_pk1_col_name,p_to_pk1_value
1458: ),
1459: EGO_COL_NAME_VALUE_PAIR_OBJ(
1460: 'DRAFT_ID',g_draft_id));
1461:
1462: l_progress := '060';
1463:

Line 1881: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

1877: ,p_message => 'l_src_template_id' || l_src_template_id
1878: );
1879: END IF;
1880:
1881: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
1882: 'BID_NUMBER', l_src_rec.bid_number
1883: ),
1884: EGO_COL_NAME_VALUE_PAIR_OBJ(
1885: 'LINE_NUMBER', l_src_rec.bid_line_number

Line 1884: EGO_COL_NAME_VALUE_PAIR_OBJ(

1880:
1881: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
1882: 'BID_NUMBER', l_src_rec.bid_number
1883: ),
1884: EGO_COL_NAME_VALUE_PAIR_OBJ(
1885: 'LINE_NUMBER', l_src_rec.bid_line_number
1886: )
1887: );
1888: IF g_debug_stmt THEN

Line 1932: EGO_COL_NAME_VALUE_PAIR_OBJ(

1928: );
1929: END IF;
1930:
1931: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1932: EGO_COL_NAME_VALUE_PAIR_OBJ(
1933: 'REQUISITION_LINE_ID',
1934: l_src_rec.requisition_line_id
1935: )
1936: );

Line 1982: EGO_COL_NAME_VALUE_PAIR_OBJ(

1978:
1979:
1980:
1981: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1982: EGO_COL_NAME_VALUE_PAIR_OBJ(
1983: 'PO_LINE_ID',l_to_pk1_value
1984: ),
1985: EGO_COL_NAME_VALUE_PAIR_OBJ(
1986: 'DRAFT_ID',g_draft_id));

Line 1985: EGO_COL_NAME_VALUE_PAIR_OBJ(

1981: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1982: EGO_COL_NAME_VALUE_PAIR_OBJ(
1983: 'PO_LINE_ID',l_to_pk1_value
1984: ),
1985: EGO_COL_NAME_VALUE_PAIR_OBJ(
1986: 'DRAFT_ID',g_draft_id));
1987:
1988:
1989: IF l_attr_group_tbl.Count > 0 THEN

Line 2132: EGO_COL_NAME_VALUE_PAIR_OBJ

2128: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
2129:
2130: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2131: (
2132: EGO_COL_NAME_VALUE_PAIR_OBJ
2133: (
2134: 'UDA_TEMPLATE_ID'
2135: ,g_tar_header_uda_template_id || ''
2136: )

Line 2503: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',g_tar_header_uda_template_id ||'' ));

2499: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
2500: INTO l_new_extension_id
2501: FROM dual;
2502:
2503: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',g_tar_header_uda_template_id ||'' ));
2504:
2505: l_process_attr_row_tbl(1).ATTR_GROUP_ID := get_ag_id('PO_HEADER_EXT_ATTRS','addresses');
2506: l_process_attr_row_tbl(1).ATTR_GROUP_APP_ID := 201;
2507: l_process_attr_row_tbl(1).DATA_LEVEL :='PO_HEADER';

Line 2859: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

2855: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
2856: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2857:
2858: l_ext_attr_value_pairs_ind NUMBER;
2859: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
2860:
2861: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE; -- not initializing this one
2862:
2863: x_return_status VARCHAR2(1);

Line 2907: EGO_COL_NAME_VALUE_PAIR_OBJ(

2903:
2904: l_progress := '020';
2905:
2906: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2907: EGO_COL_NAME_VALUE_PAIR_OBJ(
2908: p_pk1_col_name, p_pk1_col_value
2909: ),
2910: EGO_COL_NAME_VALUE_PAIR_OBJ(
2911: p_pk2_col_name,p_pk2_col_value)

Line 2910: EGO_COL_NAME_VALUE_PAIR_OBJ(

2906: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2907: EGO_COL_NAME_VALUE_PAIR_OBJ(
2908: p_pk1_col_name, p_pk1_col_value
2909: ),
2910: EGO_COL_NAME_VALUE_PAIR_OBJ(
2911: p_pk2_col_name,p_pk2_col_value)
2912: );
2913: l_progress := '040';
2914: SELECT entity_code

Line 3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)

3026:
3027: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3028:
3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')
3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')
3034: );

Line 3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')

3027: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3028:
3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')
3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')
3034: );
3035:

Line 3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')

3028:
3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')
3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')
3034: );
3035:
3036: l_progress := '140';

Line 3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')

3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')
3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')
3034: );
3035:
3036: l_progress := '140';
3037: po_uda_import_pkg.execute_import_uda_function

Line 3132: EGO_COL_NAME_VALUE_PAIR_OBJ(

3128: g_target_func_area := 'PURCHASING';
3129: g_target_doc_style := l_document_style_id;
3130:
3131: g_tar_head_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3132: EGO_COL_NAME_VALUE_PAIR_OBJ(
3133: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3134: ),
3135: EGO_COL_NAME_VALUE_PAIR_OBJ(
3136: 'DRAFT_ID',g_draft_id)

Line 3135: EGO_COL_NAME_VALUE_PAIR_OBJ(

3131: g_tar_head_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3132: EGO_COL_NAME_VALUE_PAIR_OBJ(
3133: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3134: ),
3135: EGO_COL_NAME_VALUE_PAIR_OBJ(
3136: 'DRAFT_ID',g_draft_id)
3137: );
3138:
3139: g_tar_header_uda_template_id := get_uda_template_id

Line 3424: EGO_COL_NAME_VALUE_PAIR_OBJ(

3420: );
3421: END IF;
3422:
3423: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3424: EGO_COL_NAME_VALUE_PAIR_OBJ(
3425: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3426: ),
3427: EGO_COL_NAME_VALUE_PAIR_OBJ(
3428: 'DRAFT_ID', -1

Line 3427: EGO_COL_NAME_VALUE_PAIR_OBJ(

3423: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3424: EGO_COL_NAME_VALUE_PAIR_OBJ(
3425: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3426: ),
3427: EGO_COL_NAME_VALUE_PAIR_OBJ(
3428: 'DRAFT_ID', -1
3429: ));
3430: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3431: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 3431: EGO_COL_NAME_VALUE_PAIR_OBJ(

3427: EGO_COL_NAME_VALUE_PAIR_OBJ(
3428: 'DRAFT_ID', -1
3429: ));
3430: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3431: EGO_COL_NAME_VALUE_PAIR_OBJ(
3432: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3433: ),
3434: EGO_COL_NAME_VALUE_PAIR_OBJ(
3435: 'DRAFT_ID',g_draft_id));

Line 3434: EGO_COL_NAME_VALUE_PAIR_OBJ(

3430: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3431: EGO_COL_NAME_VALUE_PAIR_OBJ(
3432: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3433: ),
3434: EGO_COL_NAME_VALUE_PAIR_OBJ(
3435: 'DRAFT_ID',g_draft_id));
3436:
3437:
3438: BEGIN

Line 3475: EGO_COL_NAME_VALUE_PAIR_OBJ(

3471:
3472: END;
3473:
3474: l_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3475: EGO_COL_NAME_VALUE_PAIR_OBJ(
3476: 'PK1_VALUE', null
3477: )
3478: );
3479: