DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_PERIOD_STATUSES

Line 30: -- Create a CN status record in CN_PERIOD_STATUSES if it doesn't exist.

26: --+
27: -- Procedure Name
28: -- Check_CN_Period_Record
29: -- Purpose
30: -- Create a CN status record in CN_PERIOD_STATUSES if it doesn't exist.
31: --+
32:
33: PROCEDURE Check_CN_Period_Record (x_org_id NUMBER, -- MOAC Change
34: x_period_name VARCHAR2,

Line 54: PROCEDURE Set_Dates ( x_start_period_id cn_period_statuses.period_id%TYPE,

50: -- Purpose
51: -- Return a data range. Used by Collection/Notify code.
52: --+
53:
54: PROCEDURE Set_Dates ( x_start_period_id cn_period_statuses.period_id%TYPE,
55: x_end_period_id cn_period_statuses.period_id%TYPE,
56: x_org_id cn_period_statuses.org_id%TYPE,
57: x_start_date OUT NOCOPY DATE,
58: x_end_date OUT NOCOPY DATE) ;

Line 55: x_end_period_id cn_period_statuses.period_id%TYPE,

51: -- Return a data range. Used by Collection/Notify code.
52: --+
53:
54: PROCEDURE Set_Dates ( x_start_period_id cn_period_statuses.period_id%TYPE,
55: x_end_period_id cn_period_statuses.period_id%TYPE,
56: x_org_id cn_period_statuses.org_id%TYPE,
57: x_start_date OUT NOCOPY DATE,
58: x_end_date OUT NOCOPY DATE) ;
59:

Line 56: x_org_id cn_period_statuses.org_id%TYPE,

52: --+
53:
54: PROCEDURE Set_Dates ( x_start_period_id cn_period_statuses.period_id%TYPE,
55: x_end_period_id cn_period_statuses.period_id%TYPE,
56: x_org_id cn_period_statuses.org_id%TYPE,
57: x_start_date OUT NOCOPY DATE,
58: x_end_date OUT NOCOPY DATE) ;
59:
60: PROCEDURE populate_srp_tables(errbuf OUT NOCOPY VARCHAR2,