DBA Data[Home] [Help]

APPS.IBE_ADDRESS_V2PVT dependencies on IBE_ORD_ONECLICK_ALL

Line 133: IBE_ORD_ONECLICK_ALL

129: end;
130: --3639679 begin
131: if p_primary_shipto = FND_API.G_TRUE then
132: UPDATE
133: IBE_ORD_ONECLICK_ALL
134: SET
135: LAST_UPDATE_DATE = sysdate,
136: SHIP_TO_PTY_SITE_ID = x_party_site_id
137: WHERE

Line 144: IBE_ORD_ONECLICK_ALL

140: end if;
141:
142: if p_primary_billto = FND_API.G_TRUE then
143: UPDATE
144: IBE_ORD_ONECLICK_ALL
145: SET
146: LAST_UPDATE_DATE = sysdate,
147: BILL_TO_PTY_SITE_ID = x_party_site_id
148: WHERE

Line 711: IBE_ORD_ONECLICK_ALL

707: -- Update one click setting with new party site id
708: --
709: --fix 2766830
710: UPDATE
711: IBE_ORD_ONECLICK_ALL
712: SET
713: LAST_UPDATE_DATE = sysdate,
714: SHIP_TO_PTY_SITE_ID = x_party_site_id
715: WHERE

Line 719: IBE_ORD_ONECLICK_ALL

715: WHERE
716: SHIP_TO_PTY_SITE_ID = p_party_site_id;
717:
718: UPDATE
719: IBE_ORD_ONECLICK_ALL
720: SET
721: LAST_UPDATE_DATE = sysdate,
722: BILL_TO_PTY_SITE_ID = x_party_site_id
723: WHERE

Line 896: IBE_ORD_ONECLICK_ALL

892: -- Set party site id to null
893: --
894: --fix 2766830
895: UPDATE
896: IBE_ORD_ONECLICK_ALL
897: SET
898: ENABLED_FLAG = 'N',
899: LAST_UPDATE_DATE = sysdate,
900: SHIP_TO_PTY_SITE_ID = null

Line 905: IBE_ORD_ONECLICK_ALL

901: WHERE
902: SHIP_TO_PTY_SITE_ID = p_party_site_id;
903:
904: UPDATE
905: IBE_ORD_ONECLICK_ALL
906: SET
907: ENABLED_FLAG = 'N',
908: LAST_UPDATE_DATE = sysdate,
909: BILL_TO_PTY_SITE_ID = null