APPS.CS_CF_SOURCE_CXT_TARGETS_PKG dependencies on CS_CF_SOURCE_CXT_TARGETS

Line 1: package body CS_CF_SOURCE_CXT_TARGETS_PKG as

1: package body CS_CF_SOURCE_CXT_TARGETS_PKG as
2: /* $Header: CSCFCTAB.pls 120.0 2005/06/01 12:26:22 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SOURCE_CONTEXT_TARGET_ID in NUMBER,

Line 55: cursor C is select ROWID from CS_CF_SOURCE_CXT_TARGETS

51: X_ADDITIONAL_INFO14 in VARCHAR2,
52: X_ADDITIONAL_INFO15 in VARCHAR2
53:
54: ) is
55: cursor C is select ROWID from CS_CF_SOURCE_CXT_TARGETS
56: where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
57:
58:
59: begin

Line 60: insert into CS_CF_SOURCE_CXT_TARGETS (

56: where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
57:
58:
59: begin
60: insert into CS_CF_SOURCE_CXT_TARGETS (
61: SOURCE_CONTEXT_TARGET_ID,
62: SOURCE_CONTEXT_TYPE_ID,
63: CONTEXT_VALUE1,
64: CONTEXT_VALUE2,

Line 258: from CS_CF_SOURCE_CXT_TARGETS

254: ADDITIONAL_INFO12,
255: ADDITIONAL_INFO13,
256: ADDITIONAL_INFO14,
257: ADDITIONAL_INFO15
258: from CS_CF_SOURCE_CXT_TARGETS
259: where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID
260: for update of SOURCE_CONTEXT_TARGET_ID nowait;
261: recinfo c%rowtype;
262:

Line 419: update CS_CF_SOURCE_CXT_TARGETS set

415:
416: begin
417:
418:
419: update CS_CF_SOURCE_CXT_TARGETS set
420: SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID,
421: CONTEXT_VALUE1 = X_CONTEXT_VALUE1,
422: CONTEXT_VALUE2 = X_CONTEXT_VALUE2,
423: CONTEXT_VALUE3 = X_CONTEXT_VALUE3,

Line 479: delete from CS_CF_SOURCE_CXT_TARGETS

475: X_SOURCE_CONTEXT_TARGET_ID in NUMBER
476: ) is
477: begin
478:
479: delete from CS_CF_SOURCE_CXT_TARGETS
480: where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
481:
482: if (sql%notfound) then
483: raise no_data_found;

Line 552: from CS_CF_SOURCE_CXT_TARGETS

548:
549:
550: select LAST_UPDATED_BY, LAST_UPDATE_DATE
551: into db_luby, db_ludate
552: from CS_CF_SOURCE_CXT_TARGETS
553: where source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID;
554:
555: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
556: -- Update existing row

Line 591: FROM CS_CF_SOURCE_CXT_TARGETS

587: l_attribute12,
588: l_attribute13,
589: l_attribute14,
590: l_attribute15
591: FROM CS_CF_SOURCE_CXT_TARGETS
592: WHERE source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID
593: FOR UPDATE ;
594:
595: CS_CF_SOURCE_CXT_TARGETS_PKG.Update_Row(

Line 595: CS_CF_SOURCE_CXT_TARGETS_PKG.Update_Row(

591: FROM CS_CF_SOURCE_CXT_TARGETS
592: WHERE source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID
593: FOR UPDATE ;
594:
595: CS_CF_SOURCE_CXT_TARGETS_PKG.Update_Row(
596: X_SOURCE_CONTEXT_TARGET_ID => to_number(X_SOURCE_CONTEXT_TARGET_ID),
597: X_SOURCE_CONTEXT_TYPE_ID => to_number(X_SOURCE_CONTEXT_TYPE_ID),
598: X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,
599: X_CONTEXT_VALUE2 => X_CONTEXT_VALUE2,

Line 646: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(

642: end if;
643: exception
644: when no_data_found then
645: -- Record doesn't exist -- insert in all cases
646: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
647: X_ROWID => l_rowid,
648: X_SOURCE_CONTEXT_TARGET_ID => X_SOURCE_CONTEXT_TARGET_ID,
649: X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
650: X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,

Line 698: end CS_CF_SOURCE_CXT_TARGETS_PKG;

694: X_LAST_UPDATED_BY => f_luby,
695: X_LAST_UPDATE_LOGIN => 0);
696: end LOAD_ROW;
697:
698: end CS_CF_SOURCE_CXT_TARGETS_PKG;