[Home] [Help]
102: l_return_status VARCHAR2(1);
103:
104: cursor c_attr_seq is
105: select PSB_ATTRIBUTES_S.NEXTVAL seq
106: from dual;
107:
108: cursor c_attrval_seq is
109: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq
110: from dual;
106: from dual;
107:
108: cursor c_attrval_seq is
109: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq
110: from dual;
111:
112: cursor c_attr is
113: select *
114: from PSB_ATTRIBUTES
498: where position_set_group_id = possetgrpid;
499:
500: cursor c_elem_seq is
501: select psb_pay_elements_s.nextval seq
502: from dual;
503:
504: cursor c_elemoptions_seq is
505: select psb_pay_element_options_s.nextval seq
506: from dual;
502: from dual;
503:
504: cursor c_elemoptions_seq is
505: select psb_pay_element_options_s.nextval seq
506: from dual;
507:
508: cursor c_elemrates_seq is
509: select psb_pay_element_rates_s.nextval seq
510: from dual;
506: from dual;
507:
508: cursor c_elemrates_seq is
509: select psb_pay_element_rates_s.nextval seq
510: from dual;
511:
512: cursor c_posset_seq is
513: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
514: from dual;
510: from dual;
511:
512: cursor c_posset_seq is
513: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
514: from dual;
515:
516: cursor c_possetline_seq is
517: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq
518: from dual;
514: from dual;
515:
516: cursor c_possetline_seq is
517: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq
518: from dual;
519:
520: cursor c_possetlineval_seq is
521: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq
522: from dual;
518: from dual;
519:
520: cursor c_possetlineval_seq is
521: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq
522: from dual;
523:
524: cursor c_setrel_seq is
525: select PSB_SET_RELATIONS_S.NEXTVAL seq
526: from dual;
522: from dual;
523:
524: cursor c_setrel_seq is
525: select PSB_SET_RELATIONS_S.NEXTVAL seq
526: from dual;
527:
528: cursor c_elempossetgrp_seq is
529: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
530: from dual;
526: from dual;
527:
528: cursor c_elempossetgrp_seq is
529: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
530: from dual;
531:
532: cursor c_elemdist_seq is
533: select PSB_PAY_ELEMENT_DISTRIBUTION_S.NEXTVAL seq
534: from dual;
530: from dual;
531:
532: cursor c_elemdist_seq is
533: select PSB_PAY_ELEMENT_DISTRIBUTION_S.NEXTVAL seq
534: from dual;
535:
536: BEGIN
537:
538: for c_elem_rec in c_elem loop
1337: and data_extract_id = g_global_data_extract_id;
1338:
1339: cursor c_emp_seq is
1340: select PSB_EMPLOYEES_S.NEXTVAL seq
1341: from dual;
1342:
1343: BEGIN
1344:
1345: -- Loop for all employees in the local data extract
1518: and (worksheet_id is null or worksheet_id = p_local_worksheet_id);
1519:
1520: cursor c_pos_seq is
1521: select PSB_POSITIONS_S.NEXTVAL seq
1522: from dual;
1523:
1524: cursor c_posassign_seq is
1525: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq
1526: from dual;
1522: from dual;
1523:
1524: cursor c_posassign_seq is
1525: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq
1526: from dual;
1527:
1528: cursor c_posdistr_seq is
1529: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq
1530: from dual;
1526: from dual;
1527:
1528: cursor c_posdistr_seq is
1529: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq
1530: from dual;
1531:
1532: BEGIN
1533:
1534: -- Loop for all positions in the local data extract
1872: and global_worksheet_id = g_global_worksheet_id;
1873:
1874: cursor c_sp_seq is
1875: select PSB_SERVICE_PACKAGES_S.NEXTVAL seq
1876: from dual;
1877:
1878: BEGIN
1879:
1880: -- Loop for all service packages in the local worksheet
2005: and b.position_id = posid;
2006:
2007: cursor c_position_exists (posid NUMBER) is
2008: select 'Exists'
2009: from dual
2010: where exists
2011: (select 1
2012: from PSB_WS_POSITION_LINES a,
2013: PSB_WS_LINES_POSITIONS b