APPS.PQP_PTY_INS dependencies on PQP_PTY_SHD

Line 80: (p_rec in out nocopy pqp_pty_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pqp_pty_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: pqp_pty_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pqp_pension_types_f t
92: where t.pension_type_id = p_rec.pension_type_id
93: and t.effective_start_date =
94: pqp_pty_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqp_pension_types_f.created_by%TYPE;

Line 366: pqp_pty_shd.constraint_error

362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated
365: --
366: pqp_pty_shd.constraint_error
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: --

Line 371: pqp_pty_shd.constraint_error

367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: --
371: pqp_pty_shd.constraint_error
372: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
373: When Others Then
374: --
375: Raise;

Line 430: (p_rec in out nocopy pqp_pty_shd.g_rec_type

426: -- ----------------------------------------------------------------------------
427: -- |------------------------------< insert_dml >------------------------------|
428: -- ----------------------------------------------------------------------------
429: Procedure insert_dml
430: (p_rec in out nocopy pqp_pty_shd.g_rec_type
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
433: ,p_validation_start_date in date
434: ,p_validation_end_date in date

Line 493: (p_rec in out nocopy pqp_pty_shd.g_rec_type

489: --
490: -- {End Of Comments}
491: -- ----------------------------------------------------------------------------
492: Procedure pre_insert
493: (p_rec in out nocopy pqp_pty_shd.g_rec_type
494: ,p_effective_date in date
495: ,p_datetrack_mode in varchar2
496: ,p_validation_start_date in date
497: ,p_validation_end_date in date

Line 585: (p_rec in pqp_pty_shd.g_rec_type

581: --
582: -- {End Of Comments}
583: -- ----------------------------------------------------------------------------
584: Procedure post_insert
585: (p_rec in pqp_pty_shd.g_rec_type
586: ,p_effective_date in date
587: ,p_datetrack_mode in varchar2
588: ,p_validation_start_date in date
589: ,p_validation_end_date in date

Line 853: ,p_rec in pqp_pty_shd.g_rec_type

849: -- ----------------------------------------------------------------------------
850: Procedure ins_lck
851: (p_effective_date in date
852: ,p_datetrack_mode in varchar2
853: ,p_rec in pqp_pty_shd.g_rec_type
854: ,p_validation_start_date out nocopy date
855: ,p_validation_end_date out nocopy date
856: ) is
857: --

Line 893: ,p_rec in out nocopy pqp_pty_shd.g_rec_type

889: -- |---------------------------------< ins >----------------------------------|
890: -- ----------------------------------------------------------------------------
891: Procedure ins
892: (p_effective_date in date
893: ,p_rec in out nocopy pqp_pty_shd.g_rec_type
894: ) is
895: --
896: l_proc varchar2(72) := g_package||'ins';
897: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 1064: l_rec pqp_pty_shd.g_rec_type;

1060: ,p_effective_start_date out nocopy date
1061: ,p_effective_end_date out nocopy date
1062: ) is
1063: --
1064: l_rec pqp_pty_shd.g_rec_type;
1065: l_proc varchar2(72) := g_package||'ins';
1066: --
1067: Begin
1068: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1074: pqp_pty_shd.convert_args

1070: -- Call conversion function to turn arguments into the
1071: -- p_rec structure.
1072: --
1073: l_rec :=
1074: pqp_pty_shd.convert_args
1075: (null
1076: ,null
1077: ,null
1078: ,p_pension_type_name