[Home] [Help]
163: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE);
164:
165: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
166: p_policy_id IN ap_pol_headers.policy_id%TYPE,
167: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
168:
169: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
170: p_policy_id IN ap_pol_headers.policy_id%TYPE,
171: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
167: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
168:
169: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
170: p_policy_id IN ap_pol_headers.policy_id%TYPE,
171: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
172:
173: PROCEDURE permutateConusLines( p_user_id IN NUMBER,
174: p_policy_id IN ap_pol_headers.policy_id%TYPE);
175:
1969: LAST_UPDATE_DATE,
1970: LAST_UPDATED_BY
1971: )
1972: select
1973: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
1974: :p_policy_id AS POLICY_ID,
1975: :p_schedule_period_id AS SCHEDULE_PERIOD_ID,
1976: NEW_LOCATION_ID AS LOCATION_ID,
1977: NEW_ROLE_ID AS ROLE_ID,
3416: LAST_UPDATE_DATE,
3417: LAST_UPDATED_BY
3418: )
3419: select
3420: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
3421: :p_to_policy_id AS POLICY_ID,
3422: :p_to_schedule_period_id AS SCHEDULE_PERIOD_ID,
3423: LOCATION_ID,
3424: ROLE_ID,
3540: |
3541: *=======================================================================*/
3542: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
3543: p_policy_id IN ap_pol_lines.policy_id%TYPE,
3544: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
3545: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE) IS
3546:
3547: l_preserve_count NUMBER := 0;
3548:
3606: LAST_UPDATED_BY
3607: )
3608: select
3609: p_policy_line_id AS PARENT_LINE_ID,
3610: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
3611: p_policy_id AS POLICY_ID,
3612: p_schedule_period_id AS SCHEDULE_PERIOD_ID,
3613: LOCATION_ID,
3614: ROLE_ID,
4981: LAST_UPDATE_DATE,
4982: LAST_UPDATED_BY
4983: )
4984: select
4985: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
4986: :p_policy_id AS POLICY_ID,
4987: :p_schedule_period_id AS SCHEDULE_PERIOD_ID,
4988: NEW_LOCATION_ID AS LOCATION_ID,
4989: NEW_ROLE_ID AS ROLE_ID,
5294: |
5295: *=======================================================================*/
5296: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
5297: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5298: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5299:
5300: l_policy_line_count NUMBER;
5301:
5302: BEGIN
5336: LAST_UPDATE_DATE,
5337: LAST_UPDATED_BY
5338: )
5339: select
5340: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
5341: apl.POLICY_ID,
5342: apl.SCHEDULE_PERIOD_ID,
5343: apl.location_id,
5344: apl.role_id,
5401: LAST_UPDATE_DATE,
5402: LAST_UPDATED_BY
5403: )
5404: select
5405: AP_POL_LINES_S.NEXTVAL AS POLICY_LINE_ID,
5406: apl.POLICY_ID,
5407: apl.SCHEDULE_PERIOD_ID,
5408: apl.location_id,
5409: apl.role_id,
5477: |
5478: *=======================================================================*/
5479: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
5480: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5481: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5482:
5483: -- -------------------------------------
5484: -- Cursor for inserting new permutation
5485: -- -------------------------------------
5582: LAST_UPDATED_BY
5583: )
5584: values
5585: (
5586: AP_POL_LINES_S.NEXTVAL,
5587: c_nightrate.POLICY_ID,
5588: c_nightrate.SCHEDULE_PERIOD_ID,
5589: c_nightrate.LOCATION_ID,
5590: c_nightrate.ROLE_ID,
5662: LAST_UPDATED_BY
5663: )
5664: values
5665: (
5666: AP_POL_LINES_S.NEXTVAL,
5667: c_nightrate.POLICY_ID,
5668: c_nightrate.SCHEDULE_PERIOD_ID,
5669: c_nightrate.LOCATION_ID,
5670: c_nightrate.ROLE_ID,
5973: LAST_UPDATE_LOGIN,
5974: LAST_UPDATE_DATE,
5975: LAST_UPDATED_BY
5976: )
5977: SELECT AP_POL_LINES_S.NEXTVAL,
5978: apl.POLICY_ID,
5979: apl.SCHEDULE_PERIOD_ID,
5980: apl.RATE_TYPE_CODE,
5981: 'NEW' as STATUS,
6065: | 21-Feb-2006 albowicz Created
6066: |
6067: *=======================================================================*/
6068: FUNCTION isDateInSeason (p_date DATE,
6069: p_start_of_season ap_pol_lines.start_of_season%TYPE,
6070: p_end_of_season ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2 IS
6071: l_start_month INTEGER;
6072: l_start_day INTEGER;
6073: l_end_month INTEGER;
6299: | 08-Jun-2006 krmenon Created
6300: |
6301: *=======================================================================*/
6302: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
6303: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
6304: p_std_invalid OUT NOCOPY NUMBER,
6305: p_first_invalid OUT NOCOPY NUMBER,
6306: p_last_invalid OUT NOCOPY NUMBER,
6307: p_same_invalid OUT NOCOPY NUMBER,
6388: | 08-Jun-2006 krmenon Created
6389: |
6390: *=======================================================================*/
6391: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
6392: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type) IS
6393: BEGIN
6394:
6395: UPDATE ap_pol_lines
6396: SET status = 'ACTIVE'