DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_WRAPPER_PVT dependencies on JTF_NUMBER_TABLE

Line 46: p_l_shp_list_item_id IN jtf_number_table := NULL ,

42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,

Line 47: p_l_object_version_number IN jtf_number_table := NULL ,

43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,

Line 49: p_l_created_by IN jtf_number_table := NULL ,

45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,

Line 50: p_l_last_updated_by IN jtf_number_table := NULL ,

46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,

Line 52: p_l_last_update_login IN jtf_number_table := NULL ,

48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,

Line 53: p_l_request_id IN jtf_number_table := NULL ,

49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,

Line 54: p_l_program_id IN jtf_number_table := NULL ,

50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,

Line 55: p_l_program_application_id IN jtf_number_table := NULL ,

51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,

Line 57: p_l_shp_list_id IN jtf_number_table := NULL ,

53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,

Line 58: p_l_inventory_item_id IN jtf_number_table := NULL ,

54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,

Line 59: p_l_organization_id IN jtf_number_table := NULL ,

55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,

Line 61: p_l_quantity IN jtf_number_table := NULL ,

57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,

Line 62: p_l_config_header_id IN jtf_number_table := NULL ,

58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
66: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,

Line 63: p_l_config_revision_num IN jtf_number_table := NULL ,

59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
66: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
67: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,

Line 83: p_l_org_id IN jtf_number_table := NULL ,

79: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
80: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,

Line 84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,

80: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,

Line 85: p_lr_request_id IN jtf_number_table := NULL ,

81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,

Line 86: p_lr_program_application_id IN jtf_number_table := NULL ,

82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,

Line 87: p_lr_program_id IN jtf_number_table := NULL ,

83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,

Line 89: p_lr_object_version_number IN jtf_number_table := NULL ,

85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,

Line 90: p_lr_created_by IN jtf_number_table := NULL ,

86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,

Line 92: p_lr_last_updated_by IN jtf_number_table := NULL ,

88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,

Line 94: p_lr_last_update_login IN jtf_number_table := NULL ,

90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,

Line 95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,

91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,

Line 96: p_lr_line_index IN jtf_number_table := NULL ,

92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER

Line 97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,

93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER
101: );

Line 98: p_lr_related_line_index IN jtf_number_table := NULL ,

94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER
101: );
102:

Line 111: p_sl_line_ids IN jtf_number_table ,

107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 112: p_sl_line_ovns IN jtf_number_table := NULL ,

108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 207: p_sl_line_ids IN jtf_number_table ,

203: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 208: p_sl_line_ovns IN jtf_number_table := NULL ,

204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,