DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_WRAPPER_PVT dependencies on IBE_SHOP_LIST_PVT

Line 456: ) RETURN IBE_Shop_List_PVT.SL_Header_Rec_Type

452: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM
456: ) RETURN IBE_Shop_List_PVT.SL_Header_Rec_Type
457: IS
458: sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
459: BEGIN
460: IF p_h_shp_list_id = ROSETTA_G_MISS_NUM THEN

Line 458: sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

454: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM
456: ) RETURN IBE_Shop_List_PVT.SL_Header_Rec_Type
457: IS
458: sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
459: BEGIN
460: IF p_h_shp_list_id = ROSETTA_G_MISS_NUM THEN
461: sl_header_rec.shp_list_id := FND_API.G_MISS_NUM;
462: ELSE

Line 592: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type

588: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
591: p_l_org_id IN jtf_number_table := NULL
592: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
593: IS
594: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
595: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
596: l_table_size PLS_INTEGER;

Line 594: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type

590: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
591: p_l_org_id IN jtf_number_table := NULL
592: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
593: IS
594: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
595: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
596: l_table_size PLS_INTEGER;
597: i PLS_INTEGER;
598: BEGIN

Line 595: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

591: p_l_org_id IN jtf_number_table := NULL
592: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
593: IS
594: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
595: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
596: l_table_size PLS_INTEGER;
597: i PLS_INTEGER;
598: BEGIN
599: IF p_l_shp_list_item_id IS NOT NULL AND p_l_shp_list_item_id.COUNT > 0 THEN

Line 811: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type

807: p_lr_line_index IN jtf_number_table := NULL,
808: p_lr_related_shp_list_item_id IN jtf_number_table := NULL,
809: p_lr_related_line_index IN jtf_number_table := NULL,
810: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
811: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
812: IS
813: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
814: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
815: l_table_size PLS_INTEGER;

Line 813: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type

809: p_lr_related_line_index IN jtf_number_table := NULL,
810: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
811: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
812: IS
813: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
814: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
815: l_table_size PLS_INTEGER;
816: i PLS_INTEGER;
817: BEGIN

Line 814: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;

810: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
811: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
812: IS
813: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
814: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
815: l_table_size PLS_INTEGER;
816: i PLS_INTEGER;
817: BEGIN
818: IF p_lr_shlitem_rel_id IS NOT NULL AND p_lr_shlitem_rel_id.COUNT > 0 THEN

Line 1032: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

1028: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
1029: x_sl_header_id OUT NOCOPY NUMBER
1030: )
1031: IS
1032: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1033: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type;
1034: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
1035: BEGIN
1036:

Line 1033: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type;

1029: x_sl_header_id OUT NOCOPY NUMBER
1030: )
1031: IS
1032: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1033: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type;
1034: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
1035: BEGIN
1036:
1037: l_sl_header_rec := Construct_SL_Header_Rec(

Line 1034: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;

1030: )
1031: IS
1032: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1033: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type;
1034: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
1035: BEGIN
1036:
1037: l_sl_header_rec := Construct_SL_Header_Rec(
1038: p_h_shp_list_id => p_h_shp_list_id,

Line 1129: IBE_Shop_List_PVT.Save(

1125: p_lr_related_shp_list_item_id => p_lr_related_shp_list_item_id,
1126: p_lr_related_line_index => p_lr_related_line_index ,
1127: p_lr_relationship_type_code => p_lr_relationship_type_code);
1128:
1129: IBE_Shop_List_PVT.Save(
1130: p_api_version => p_api_version ,
1131: p_init_msg_list => p_init_msg_list ,
1132: p_commit => p_commit ,
1133: x_return_status => x_return_status ,

Line 1190: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

1186: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
1187: x_sl_header_id OUT NOCOPY NUMBER
1188: )
1189: IS
1190: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1191: BEGIN
1192: l_sl_header_rec := Construct_SL_Header_Rec(
1193: p_h_shp_list_id => p_h_shp_list_id,
1194: p_h_request_id => p_h_request_id,

Line 1226: IBE_Shop_List_PVT.Save_List_From_Items(

1222: p_h_attribute14 => p_h_attribute14,
1223: p_h_attribute15 => p_h_attribute15,
1224: p_h_org_id => p_h_org_id);
1225:
1226: IBE_Shop_List_PVT.Save_List_From_Items(
1227: p_api_version => p_api_version ,
1228: p_init_msg_list => p_init_msg_list ,
1229: p_commit => p_commit ,
1230: x_return_status => x_return_status ,

Line 1290: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

1286: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
1287: x_sl_header_id OUT NOCOPY NUMBER
1288: )
1289: IS
1290: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1291: BEGIN
1292: l_sl_header_rec := Construct_SL_Header_Rec(
1293: p_h_shp_list_id => p_h_shp_list_id,
1294: p_h_request_id => p_h_request_id,

Line 1326: IBE_Shop_List_PVT.Save_List_From_Quote(

1322: p_h_attribute14 => p_h_attribute14,
1323: p_h_attribute15 => p_h_attribute15,
1324: p_h_org_id => p_h_org_id);
1325:
1326: IBE_Shop_List_PVT.Save_List_From_Quote(
1327: p_api_version => p_api_version ,
1328: p_init_msg_list => p_init_msg_list ,
1329: p_commit => p_commit ,
1330: x_return_status => x_return_status ,

Line 1585: IBE_Shop_List_PVT.Save_Quote_From_List_Items(

1581: p_h_order_type_name => p_h_order_type_name ,
1582: p_h_ordered_date => p_h_ordered_date ,
1583: p_h_resource_id => p_h_resource_id);
1584:
1585: IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1586: p_api_version => p_api_version ,
1587: p_init_msg_list => p_init_msg_list ,
1588: p_commit => p_commit ,
1589: x_return_status => x_return_status ,