APPS.AMS_CAMPAIGNS_ALL_PKG dependencies on AMS_CAMPAIGNS_ALL_B

Line 90: cursor C is select ROWID from AMS_CAMPAIGNS_ALL_B

86: X_LAST_UPDATE_DATE in DATE,
87: X_LAST_UPDATED_BY in NUMBER,
88: X_LAST_UPDATE_LOGIN in NUMBER
89: ) is
90: cursor C is select ROWID from AMS_CAMPAIGNS_ALL_B
91: where CAMPAIGN_ID = X_CAMPAIGN_ID
92: ;
93: begin
94: insert into AMS_CAMPAIGNS_ALL_B (

Line 94: insert into AMS_CAMPAIGNS_ALL_B (

90: cursor C is select ROWID from AMS_CAMPAIGNS_ALL_B
91: where CAMPAIGN_ID = X_CAMPAIGN_ID
92: ;
93: begin
94: insert into AMS_CAMPAIGNS_ALL_B (
95: CAMPAIGN_ID,
96: OBJECT_VERSION_NUMBER,
97: OWNER_USER_ID,
98: USER_STATUS_ID,

Line 459: from AMS_CAMPAIGNS_ALL_B

455: ATTRIBUTE12,
456: ATTRIBUTE14,
457: ATTRIBUTE13,
458: ATTRIBUTE15
459: from AMS_CAMPAIGNS_ALL_B
460: where CAMPAIGN_ID = X_CAMPAIGN_ID
461: for update of CAMPAIGN_ID nowait;
462: recinfo c%rowtype;
463:

Line 729: update AMS_CAMPAIGNS_ALL_B set

725: X_LAST_UPDATED_BY in NUMBER,
726: X_LAST_UPDATE_LOGIN in NUMBER
727: ) is
728: begin
729: update AMS_CAMPAIGNS_ALL_B set
730: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
731: OWNER_USER_ID = X_OWNER_USER_ID,
732: USER_STATUS_ID = X_USER_STATUS_ID,
733: STATUS_CODE = X_STATUS_CODE,

Line 841: delete from AMS_CAMPAIGNS_ALL_B

837: if (sql%notfound) then
838: raise no_data_found;
839: end if;
840:
841: delete from AMS_CAMPAIGNS_ALL_B
842: where CAMPAIGN_ID = X_CAMPAIGN_ID;
843:
844: if (sql%notfound) then
845: raise no_data_found;

Line 855: from AMS_CAMPAIGNS_ALL_B B

851: begin
852: delete from AMS_CAMPAIGNS_ALL_TL T
853: where not exists
854: (select NULL
855: from AMS_CAMPAIGNS_ALL_B B
856: where B.CAMPAIGN_ID = T.CAMPAIGN_ID
857: );
858:
859: update AMS_CAMPAIGNS_ALL_TL T set (

Line 1035: from ams_campaigns_all_b

1031: l_row_id varchar2(100);
1032:
1033: cursor c_version is
1034: select object_version_number
1035: from ams_campaigns_all_b
1036: where campaign_id = X_CAMPAIGN_ID;
1037:
1038: cursor c_camp_exists is
1039: select 'x'

Line 1040: from ams_campaigns_all_b

1036: where campaign_id = X_CAMPAIGN_ID;
1037:
1038: cursor c_camp_exists is
1039: select 'x'
1040: from ams_campaigns_all_b
1041: where campaign_id = X_CAMPAIGN_ID;
1042:
1043: cursor c_camp_id is
1044: select ams_campaigns_all_b_s.nextval

Line 1044: select ams_campaigns_all_b_s.nextval

1040: from ams_campaigns_all_b
1041: where campaign_id = X_CAMPAIGN_ID;
1042:
1043: cursor c_camp_id is
1044: select ams_campaigns_all_b_s.nextval
1045: from dual;
1046:
1047: BEGIN
1048: