DBA Data[Home] [Help]

APPS.CE_BA_SIGNATORY_HISTORY dependencies on CE_BA_SIGNATORY_HIST_H

Line 68: CURSOR C IS SELECT rowid FROM CE_BA_SIGNATORY_HIST_H

64: X_Attribute13 VARCHAR2,
65: X_Attribute14 VARCHAR2,
66: X_Attribute15 VARCHAR2
67: ) IS
68: CURSOR C IS SELECT rowid FROM CE_BA_SIGNATORY_HIST_H
69: WHERE signatory_history_id = X_signatory_history_id;
70:
71: CURSOR C2 IS SELECT ce_ba_signatory_hist_h_s.nextval FROM sys.dual;
72: --

Line 71: CURSOR C2 IS SELECT ce_ba_signatory_hist_h_s.nextval FROM sys.dual;

67: ) IS
68: CURSOR C IS SELECT rowid FROM CE_BA_SIGNATORY_HIST_H
69: WHERE signatory_history_id = X_signatory_history_id;
70:
71: CURSOR C2 IS SELECT ce_ba_signatory_hist_h_s.nextval FROM sys.dual;
72: --
73: BEGIN
74: -- cep_standard.debug('open c2 ');
75:

Line 81: INSERT INTO CE_BA_SIGNATORY_HIST_H(

77: FETCH C2 INTO X_Signatory_history_id;
78: CLOSE C2;
79: --
80:
81: INSERT INTO CE_BA_SIGNATORY_HIST_H(
82: signatory_id,
83: signatory_history_id,
84: approver_person_id,
85: action,