APPS.INVPCOII dependencies on CST_LISTS

Line 334: Select cst_lists_s.nextval

330: NULL -- attribute15
331: from mtl_parameters mp
332: where mp.organization_id = i_organization_id;
333:
334: Select cst_lists_s.nextval
335: INTO cost_update
336: From DUAL;
337:
338:

Line 637: select cst_lists_s.nextval

633: ** so no further checks required.
634: */
635:
636: l_location := 410;
637: select cst_lists_s.nextval
638: into l_list_id
639: from dual;
640:
641: FOR cc1 IN cst1 LOOP

Line 681: delete from cst_lists

677: I_PRGM_APPL_ID,
678: l_return_status);
679:
680: l_location := 430;
681: delete from cst_lists
682: where list_id = l_list_id;
683:
684: Temp_Org_Id := cc1.organization_id;
685: Temp_Cost_Type := cc1.primary_cost_method;

Line 691: insert into cst_lists (LIST_ID,ENTITY_ID)

687: Temp_Cost_Org_Id := cc1.cost_organization_id;
688: end if;
689:
690: l_location := 420;
691: insert into cst_lists (LIST_ID,ENTITY_ID)
692: values (l_list_id,cc1.inventory_item_id);
693:
694: If (l_return_status <> 0) Then
695: l_org_id := cc1.organization_id;

Line 713: delete from cst_lists

709: l_return_status);
710:
711:
712: l_location := 480;
713: delete from cst_lists
714: where list_id = l_list_id;
715:
716: -- commented following one code line added the next one to fix 7108920
717: -- Temp_Org_Id := 0;

Line 774: delete from cst_lists

770: l_return_status);
771:
772:
773: l_location := 450;
774: delete from cst_lists
775: where list_id = l_list_id;
776:
777: Temp_Org_Id := cc2.organization_id;
778: Temp_Cost_Type := cc2.primary_cost_method;

Line 784: insert into cst_lists (LIST_ID,ENTITY_ID)

780: Temp_Cost_Org_Id := cc2.cost_organization_id;
781: end if;
782:
783: l_location := 440;
784: insert into cst_lists (LIST_ID,ENTITY_ID)
785: values (l_list_id,cc2.inventory_item_id);
786:
787: If (l_return_status <> 0) Then
788: l_org_id := cc2.organization_id;

Line 799: from cst_lists

795: END LOOP; /* cst2 cursor */
796:
797: select count(*)
798: into New_List_ct
799: from cst_lists
800: where list_id = l_list_id
801: and rownum =1;
802:
803: if (New_list_ct = 1) then

Line 816: delete from cst_lists

812: l_return_status);
813:
814:
815: l_location := 480;
816: delete from cst_lists
817: where list_id = l_list_id;
818: End if;
819: -- commented following one code line added the next one to fix 7108920
820: -- Temp_Org_Id := 0;

Line 878: delete from cst_lists

874: l_return_status);
875:
876:
877: l_location := 470;
878: delete from cst_lists
879: where list_id = l_list_id;
880:
881: Temp_Org_Id := cc3.organization_id;
882: Temp_Cost_Type := cc3.primary_cost_method;

Line 888: insert into cst_lists (LIST_ID,ENTITY_ID)

884: Temp_Cost_Org_Id := cc3.master_organization_id;
885: end if;
886:
887: l_location := 460;
888: insert into cst_lists (LIST_ID,ENTITY_ID)
889: values (l_list_id,cc3.inventory_item_id);
890:
891: If (l_return_status <> 0) Then
892: l_org_id := cc3.organization_id;

Line 903: from cst_lists

899: END LOOP; /* cst3 cursor */
900: -- Calling this for the last org for cc3 cursor
901: select count(*)
902: into New_List_ct
903: from cst_lists
904: where list_id = l_list_id
905: and rownum =1;
906:
907: if (New_list_ct = 1 ) then

Line 919: delete from cst_lists

915: l_return_status);
916:
917:
918: l_location := 480;
919: delete from cst_lists
920: where list_id = l_list_id;
921:
922: end if;
923: -- commented following one code line added the next one to fix 7108920